ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a2149d02c0dd: POST https://beta.jinchangxiao.com/vue/project/export at 2026-06-04 05:48:00 pm by 221.216.117.119

Log Messages

总计155条数据
TimeLevelCategoryMessage
 
17:48:00.180traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:48:00.180traceyii\base\Module::getModuleLoading module: debug
17:48:00.180traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:48:00.180traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:48:00.180traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:48:00.180traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.180infotime tracing start1780566480180946944
17:48:00.181traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:48:00.181traceyii\web\Application::handleRequestRoute requested: 'vue/project/export'
17:48:00.181traceyii\base\Module::getModuleLoading module: vue
17:48:00.181infoyii\web\Session::openSession started
17:48:00.182infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:48:00.182infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:48:00.182traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.183traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:00.183traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.183traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:00.183infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:48:00.184traceyii\base\Controller::runActionRoute to run: vue/project/export
17:48:00.184traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.185traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:48:00.185traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ProjectController::actionExport()
17:48:00.185traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.185traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:00.186traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'from_contact_name' in 'app\models\search\ProjectSearch'.
17:48:00.186traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.187traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.188infoyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND (("c"."sales_rep"='1001')) GROUP BY "p"."id" ORDER BY "p"."created_at" DESC
17:48:00.211infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3463, 3462, 3311, 3389, 3304, 3009, 982, 3457, 2150, 3286, 2593, 3451, 3435, 3377, 2553, 3301, 3432, 3429, 3427, 3426, 2845, 2545, 3364, 2117, 3344, 3334, 3327, 2616, 2538, 3296, 3278, 2836, 2838, 1933, 2798, 2718, 2719, 2511, 2582, 2207, 2551, 2540, 2539, 2536, 2520, 2519, 2500, 2486, 2219, 2115, 1098, 2046, 146, 2045, 2044, 1661, 1032, 1178, 1175, 1094, 1095, 1077, 1039)
17:48:00.212infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:48:00.212infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:48:00.212infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "sales_id"=1001
17:48:00.213infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_groups" WHERE "id"=1
17:48:00.216infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 6, 3, 1)
17:48:00.216infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 80, 47, 1)
17:48:00.216infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (13, 18, 1, 3, 20, 4, 5, 10, 57)
17:48:00.217infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2800, 3304, 2125)
17:48:00.217infoyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
17:48:00.218infoyii\db\Command::querySELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88) ORDER BY "contribution" DESC, "engineer_id"
17:48:00.219traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.219traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:00.220infoyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (2, 3, 5)
17:48:00.220infoyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (5, 3, 2, 9, 6, 4, 7, 49, 10, 8)
17:48:00.221infoyii\db\Command::querySELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.224infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.228infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (97, 160, 140, 136, 46, 45, 101, 229, 100, 94, 153, 135, 175, 159, 5, 102, 2, 165, 179, 142, 1, 226, 7, 183, 187, 133, 2100000000, 213, 210, 212, 139, 137, 156, 167, 180, 215, 184, 189, 154, 131, 166, 93, 8, 232, 181, 6, 10, 265, 185, 191, 178, 128, 205, 204, 172, 174, 129, 203, 197, 194, 168, 228, 199, 171, 196, 304, 130, 200, 164, 331, 182, 307, 192, 317, 309, 155, 337, 319, 107, 198, 202, 340, 341, 348, 316, 320, 349, 313, 322, 324, 326, 350, 351, 354, 356, 359, 360, 366, 369, 371, 372, 374, 377, 332, 327, 353, 323, 333, 437, 410, 138, 315)) ORDER BY "sort"
17:48:00.230infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.234infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (97, 160, 140, 136, 46, 45, 101, 229, 100, 94, 153, 135, 175, 159, 5, 102, 2, 165, 179, 142, 1, 226, 7, 183, 187, 133, 2100000000, 213, 210, 212, 139, 137, 156, 167, 180, 215, 184, 189, 154, 131, 166, 93, 8, 232, 181, 6, 10, 265, 185, 191, 178, 128, 205, 204, 172, 174, 129, 203, 197, 194, 168, 228, 199, 171, 196, 304, 130, 200, 164, 331, 182, 307, 192, 317, 309, 155, 337, 319, 107, 198, 202, 340, 341, 348, 316, 320, 349, 313, 322, 324, 326, 350, 351, 354, 356, 359, 360, 366, 369, 371, 372, 374, 377, 332, 327, 353, 323, 333, 437, 410, 138, 315)) ORDER BY "sort"
17:48:00.235infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.239infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (97, 160, 140, 136, 46, 45, 101, 229, 100, 94, 153, 135, 175, 159, 5, 102, 2, 165, 179, 142, 1, 226, 7, 183, 187, 133, 2100000000, 213, 210, 212, 139, 137, 156, 167, 180, 215, 184, 189, 154, 131, 166, 93, 8, 232, 181, 6, 10, 265, 185, 191, 178, 128, 205, 204, 172, 174, 129, 203, 197, 194, 168, 228, 199, 171, 196, 304, 130, 200, 164, 331, 182, 307, 192, 317, 309, 155, 337, 319, 107, 198, 202, 340, 341, 348, 316, 320, 349, 313, 322, 324, 326, 350, 351, 354, 356, 359, 360, 366, 369, 371, 372, 374, 377, 332, 327, 353, 323, 333, 437, 410, 138, 315)) ORDER BY "sort"
17:48:00.241infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1004, 5295, 5300, 1005, 1003)
17:48:00.241infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1004, 1005, 5300, 1003))
17:48:00.242infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)
17:48:00.242infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5064, 1000, 1011, 1005, 1004, 5295, 5300, 1003, 5076)
17:48:00.242infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5064, 1000, 5295, 1004, 1005, 1011, 5300, 1003, 5076))
17:48:00.243infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "sales_id" IN (1001, 5064, 1000, 5295, 1004, 1005, 1011, 5300, 1003, 5076)
17:48:00.243infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_groups" WHERE "id" IN (1, 999999, 80)
17:48:00.243infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 1, 3)
17:48:00.244infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3463, 3462, 3311, 3389, 3304, 3009, 982, 3457, 2150, 3286, 2593, 3451, 3435, 3377, 2553, 3301, 3432, 3429, 3427, 3426, 2845, 2545, 3364, 2117, 3344, 3334, 3327, 2616, 2538, 3296, 3278, 2836, 2838, 1933, 2798, 2718, 2719, 2511, 2582, 2207, 2551, 2540, 2539, 2536, 2520, 2519, 2500, 2486, 2219, 2115, 1098, 2046, 146, 2045, 2044, 1661, 1032, 1178, 1175, 1094, 1095, 1077, 1039)
17:48:00.245infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:48:00.245infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:48:00.246infoyii\db\Command::querySELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", sum(points) as points FROM "a57be577deb434"."tbl_case_assignments" GROUP BY "case_id") "ca" ON ca.case_id = c.id WHERE "c"."project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88) GROUP BY "c"."project_id"
17:48:00.255traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.255traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:00.256infoyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)) GROUP BY "project_id"
17:48:00.258infoyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88) GROUP BY "project_id"
17:48:00.263infoyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)) GROUP BY "project_id"
17:48:00.266infoyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)) GROUP BY "c"."project_id"
17:48:00.279infoyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)) GROUP BY "c"."project_id"
17:48:00.286infoyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)) GROUP BY "project_id"
17:48:00.288infoyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)) GROUP BY "project_id"
17:48:00.294infoyii\db\Command::querySELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound", "erp_settle_amount", "erp_un_settle_amount", "including_tax", "amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.299infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457))
17:48:00.306infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (7226, 1451, 1755, 773, 1282, 1300, 1524, 3135, 7362, 1522, 3569, 3675, 6033, 6276, 6707, 6761, 5271, 8957, 5861, 5872, 6135, 6912, 1529, 7201, 1822, 9824, 10586, 10631, 11383, 11849, 21132, 22137, 22034, 12487, 13817, 14690, 13241, 12978, 14139, 13685, 14158, 15312, 15474, 13167, 11886, 12453, 14474, 13345, 14676, 16348, 14188, 14167, 15658, 13818, 16347, 17472, 17895, 17635, 18862, 19585, 19273, 20000, 20210, 18741, 18892, 20449, 19680, 22670, 21688, 21625, 21450, 20371, 19980, 18893, 18720, 22562, 20546, 21308, 21134, 23131, 23438, 23436, 29617, 23648, 30871, 23771, 23789, 30268, 30186, 30082, 29895, 30695, 30696, 28021, 27758, 27759, 27658, 27308, 26741, 26549, 26100, 25845, 25704, 25547, 24970, 24348, 31532, 31656, 32175, 31575, 32533)
17:48:00.373infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457))
17:48:00.379infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (6034, 6277, 6708, 6762, 5320, 5868, 5873, 6136, 6913, 1577, 7202, 7227, 1562, 1847, 9921, 134, 1428, 1583, 1569, 1869, 5408, 22643, 11251, 11252, 11925, 12876, 13174, 13349, 13460, 22491, 13664, 22509, 14159, 14160, 21870, 14685, 14686, 14231, 14957, 14691, 14843, 15632, 15719, 15731, 16358, 16753, 22187, 22188, 17716, 17999, 18167, 19035, 19329, 19410, 19673, 19849, 20030, 20201, 20211, 20446, 20473, 22828, 20715, 20922, 20932, 21135, 23594, 23714, 24180, 24240, 24375, 24525, 25024, 25594, 26397, 26404, 26642, 27072, 28023, 28096, 28131, 30353)
17:48:00.410infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457))
17:48:00.415infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (11077, 11076, 14733, 15072, 23124, 18168, 18723, 31118)
17:48:00.418infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457)) ORDER BY "id" DESC
17:48:00.421infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "collected_date" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457) ORDER BY "id" DESC
17:48:00.428infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1013, 1014, 5388, 5064, 5252)
17:48:00.429infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457) ORDER BY "id"
17:48:00.431infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5693, 5209, 5400, 5690, 5865, 6134, 6144, 6611, 6316, 6910, 6909, 7193, 7207, 7365, 7376)
17:48:00.433infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457) ORDER BY "remind_date"
17:48:00.436infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457)
17:48:00.439infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1003, 1001, 5295, 1011, 5252, 5300, 5360, 1004)
17:48:00.439infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 5252, 1004, 5360, 1005, 1011, 5300, 1003))
17:48:00.440infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457)
17:48:00.443infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (68, 163, 46, 363, 253, 531, 373, 252, 489, 82, 67, 365, 494, 511, 305, 90, 236, 617, 623, 262, 669, 676, 678, 38, 478, 608, 756, 307, 431)
17:48:00.448infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (556, 2983, 2661, 2962, 2764, 3600, 2168, 2770, 799, 676, 2839, 2605, 2674, 1665, 826, 800, 1234, 2767, 3019, 3157, 533, 1783, 1559, 2771, 2595, 2758, 2813, 2657, 1232, 1213, 3248, 2896, 1948, 2793, 2219, 2548, 2769, 842, 3123, 3503, 1695, 3574, 3466, 2482, 3704, 3726, 3727, 610, 3166, 571, 2359, 3334, 3362, 3359, 3389, 3241, 3253, 3254, 3234, 4145, 3233, 3494, 4103, 3617, 3663, 3610, 3582, 3526, 3367, 3365, 3621, 675, 3403, 3422, 3372, 2704, 4240, 3747, 3773, 4118, 3769, 4295, 4293, 4250, 4350, 3756, 4122, 4136, 4056, 4098, 4017, 4000, 3969, 3936, 3917, 3902, 3903, 3901, 3863, 3804, 4376, 4374, 4447, 4463, 4475)
17:48:00.477infoyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.478infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5250, 5016)
17:48:00.478infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5250, 5016))
17:48:00.479infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88) ORDER BY "id"
17:48:00.482infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (163, 617, 236, 511, 81, 623, 90, 262, 68, 46, 531)
17:48:00.483infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (962, 963, 964, 965, 966, 967, 968, 942, 941, 40, 466, 178, 937, 933, 938, 1205, 932, 254, 201, 566, 1226, 429, 983, 984, 971, 986, 985, 987, 988, 989, 991, 992, 993, 196, 792, 384, 955, 995, 825, 594, 974, 851, 1338, 1339, 1340, 947, 849, 1377, 1003, 1471, 1107, 1300, 1301, 1302, 1303, 850, 1577, 1640, 1491, 1492, 1494, 1639, 1655, 498, 1666, 1667, 1558, 1559, 1560, 1561, 1562, 1563, 969, 994, 1456, 1457, 1584, 1585, 1586, 1587, 1564, 1757, 1758, 1705, 972, 1108, 1422, 1423, 1624, 1787, 1788, 1789, 1781, 1782, 1783, 1784, 1785, 1657, 1650, 1668, 1763, 1764, 1766, 1895, 1896, 1897, 1910, 1911, 1912, 1353, 1902, 1903, 1904, 2042, 734, 2171, 1148, 1923, 1104, 1372, 1931, 2108, 2058, 2056, 2055, 2059, 2057, 2034, 2033, 2035, 1997, 1999, 2000, 1973, 1961, 1948, 1949, 1950, 2230, 2231, 2232, 2233, 2262, 2268, 2177, 1528, 2269, 2261, 2263, 2267)
17:48:00.486infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 2, 3, 5, 4, 19, 22, 23, 21)
17:48:00.487infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (53, 49, 14, 5, 214, 15, 35, 36, 7, 19, 43, 157, 42, 151, 68, 64, 171, 26, 4, 30, 2, 200, 141, 66, 65, 39, 195, 194, 188, 189, 159, 229, 29, 52, 221, 139)
17:48:00.487infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (138, 4, 27, 8, 43, 54, 12, 225, 134, 133, 230, 10, 23, 6, 2, 150, 139, 9, 88, 24, 179, 189, 270, 285, 287)
17:48:00.488infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1262, 1630, 857, 42, 1694, 1345, 1347, 1244, 1632, 1395, 386, 1359, 1243, 1012, 1408, 1417, 1418, 1419, 1009, 1448, 593, 592, 1486, 613, 1487, 975, 1504, 999, 1505, 1506, 1507, 615, 1665, 1382, 612, 1758, 1579, 1580, 607, 618, 784, 31, 1583, 1663, 1664, 1603, 1605, 1604, 165, 167, 877, 315, 796, 1156, 1020, 543, 801, 802, 588, 339, 885, 716, 1260, 617, 804, 356, 805, 806, 605, 606, 1261, 604, 603, 591, 529, 113, 147, 667, 666, 103, 754, 799, 803, 811, 1004, 1170, 1171, 1033, 743, 739, 1724, 1613, 1404, 1782, 1759, 1760, 1011, 525, 1769, 1781, 1784, 1785, 1786, 1358, 1344, 1047, 1730)
17:48:00.491infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 3, 1, 4, 7, 6, 8, 5, 9, 11)
17:48:00.491infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (73, 74, 75, 76, 77, 78, 79, 80, 218, 219, 220, 331, 140, 130, 131, 266, 193, 280, 281, 397, 406, 138, 3, 44, 45, 46, 47, 48, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 144, 328, 329, 500, 286, 287, 274, 275, 276, 282, 283, 284, 285, 221, 222, 223, 224, 675, 676, 677, 702, 703, 704, 705, 661, 662, 663, 664, 665, 819, 820, 926, 927, 928, 929, 930, 897, 968, 994, 995, 791, 792, 793, 794, 795, 796, 821, 822, 823, 824, 825, 1023, 965, 826, 827, 828, 829, 830, 831, 789, 790, 1173, 1174, 1209, 1287, 476, 477, 478, 1363, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1229, 1230, 1231, 1232, 1233, 1216, 987, 988, 969, 970, 971, 1299, 996, 997, 1190, 1191, 1192, 1193, 1194, 1195, 1148, 1149, 1150, 1151, 1431, 1432, 1433, 1456, 1457, 1458, 1448, 1449, 1450, 1451, 1452, 1453, 1454, 1455, 1879, 1970, 1976, 1981, 2031, 2025, 2075, 2074, 2116, 1484, 1485, 1486, 1487, 1494, 1495, 1496, 1507, 1508, 1509, 1510, 1512, 1513, 1511, 2138, 1860, 1861, 1855, 1808, 1809, 1807, 1810, 1811, 1812, 1748, 1749, 1750, 1751, 1752, 1728, 1729, 1709, 1710, 1711, 1686, 1664, 1665, 1666, 1667, 1627, 1628, 1629, 1630, 1569, 1536, 1537, 1538, 2150, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2199, 2210, 2211, 2212, 2213, 2246, 2217, 2242, 2220, 2221, 2222, 2223, 2231, 2232, 2225, 2230, 2234, 2239, 2240, 2236, 2237, 2233, 2238, 2235, 2241, 2243, 2245, 2247)
17:48:00.496infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)) GROUP BY "object_id"
17:48:00.523infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)) GROUP BY "object_id"
17:48:00.542infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (3233, 5957, 5912, 6029, 5980, 6047, 1262, 4838, 4137)
17:48:00.546infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (1262, 3233, 4137, 4838, 5912, 5957, 5980, 6029, 6047)
17:48:00.547infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=1841
17:48:00.547infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (100, 479, 68, 511, 90, 459)
17:48:00.548infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.549infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (5041, 4640, 1262, 1022, 4853, 5001, 804, 5160, 3906, 4138, 4849, 6190, 5059, 6221, 6209, 5957, 4137, 6161, 6231)
17:48:00.555infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 2545, 1933, 2598, 2150, 2712, 2540, 3377, 3286, 3432, 2553)
17:48:00.555infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (163, 100, 479, 46)
17:48:00.556infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((5041, 3246), (4640, 3263), (4640, 3225), (1262, 3660), (1262, 3503), (1262, 3514), (1022, 3216), (4853, 3318), (5001, 3235), (804, 3148), (1262, 3251), (1262, 3441), (5160, 3209), (1262, 3372), (5001, 3458), (5001, 3269), (1262, 3424), (4640, 3760), (4640, 3599), (3906, 3201), (4138, 3157), (1262, 3644), (5001, 3623), (1262, 3652), (4640, 3552), (1262, 3589), (1262, 3577), (1262, 3723), (4640, 3576), (4640, 3590), (1262, 3752), (1262, 3744), (1262, 3515), (4849, 3467), (6190, 4014), (1262, 3591), (1262, 3371), (5059, 3371), (1262, 3714), (1262, 3661), (1262, 3767), (6221, 4096), (6209, 4079), (6209, 4078), (5957, 3751), (4137, 3874), (6161, 3874), (4640, 3899), (4640, 3886), (4640, 3855), (6231, 4098), (6190, 4142))
17:48:00.557infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88))
17:48:00.563infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.564infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2800, 3304, 2125, 2150, 3432)
17:48:00.564infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (15, 57, 92, 96, 117, 122, 137, 136, 177, 153, 180, 185, 265, 266, 227, 232, 240, 271, 250, 254, 279, 322, 289, 296, 307, 326)
17:48:00.565infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:48:00.565infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:48:00.565infoyii\db\Command::querySELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id" IN (15, 57, 92, 96, 117, 122, 137, 136, 177, 153, 180, 185, 265, 266, 227, 232, 240, 271, 250, 254, 279, 322, 289, 296, 307, 326)
17:48:00.566infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (15, 57, 92, 96, 117, 122, 137, 136, 177, 153, 180, 185, 265, 266, 227, 232, 240, 271, 250, 254, 279, 322, 289, 296, 307, 326)
17:48:00.566infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=113) AND ("object_id"=1)
17:48:00.568infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32702
17:48:00.568infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:48:00.569infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:48:00.569infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (15, 57, 92, 96, 117, 122, 137, 136, 177, 153, 180, 185, 265, 266, 227, 232, 240, 271, 250, 254, 279, 322, 289, 296, 307, 326)
17:48:00.569infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=115) AND ("object_id"=1)
17:48:00.571infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32704
17:48:00.572infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:48:00.572infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:48:00.572infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=114) AND ("object_id"=1)
17:48:00.574infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32703
17:48:00.575infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88))
17:48:00.576infoyii\db\Command::querySELECT s.id, project_id, client_id, schedule_title, complete_at, start_at, end_at, created_by, is_complete, is_closed, complete_description, set_top_at, CASE WHEN is_complete = true THEN 3 WHEN is_complete = false AND end_at <= NOW() THEN 2 ELSE 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (("is_complete"=FALSE) OR ("complete_at" >= '2026-05-21')) AND ((("is_public"=1) AND ("created_by" != 1001)) OR ("created_by"=1001) OR ("ccr"."user_id"=1001)) AND ("s"."project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)) ORDER BY set_top_at DESC nulls last, sort ASC, CASE WHEN is_complete = true THEN complete_at END DESC, CASE WHEN is_complete = false THEN end_at END ASC, end_at DESC
17:48:00.586traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:48:00.586traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:48:00.586infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:48:00.587infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
17:48:00.587infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id"=18357 ORDER BY "created_at" DESC
17:48:00.589infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.594infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "collected_date" AS "from_date", "created_by" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3853, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4455, 2148, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457) ORDER BY "id" DESC
17:48:00.598infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "created_by" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3853, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4455, 2148, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457) ORDER BY "id"
17:48:00.600infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (38, 96, 388, 471, 474, 494, 538, 539, 571, 573, 610, 661, 771, 854, 893, 905, 919, 920, 932, 934, 985, 986, 1032, 1036, 1048, 1050, 1142, 1186, 1236, 1239, 1248, 1285, 1304, 1335, 1361, 1368, 1377, 1387, 1390, 1399, 1404, 1410, 1413, 1418, 1427, 1438, 1440, 1444, 1446, 1450, 1454, 1458, 1462, 1467, 1469, 1481, 1484, 1500, 1501, 1509, 1526, 1548, 1566, 1600, 1610, 1612, 1614, 1637, 1648, 1659, 1667, 1675, 1685, 1697, 1699, 1709, 1719, 1722, 1732, 1739, 1740, 1743, 1749, 1755, 1832, 1833, 1844, 1845, 1846, 1848, 1849, 1869, 1906, 1915, 1917, 1926, 1928, 1933, 1934, 1942, 1964, 1976, 2001, 2009, 2039, 2062, 2070, 2072, 2090, 2097, 2123, 2125, 2127, 2128, 2129, 2130, 2131, 2137, 2145, 2190, 2197, 2201, 2210, 2238, 2248, 2253, 2255, 2260, 2261, 2262, 2292, 2294, 2299, 2320, 2322, 2323, 2325, 2326, 2327))
17:48:00.604infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5693, 7193, 7376, 5690, 6910, 6909, 5209, 5400, 6144, 5865, 6134, 6316, 7207, 7365, 6611, 9008, 22845, 9895, 10588, 10629, 10717, 11266, 11393, 11912, 12281, 12535, 12828, 22449, 12986, 13154, 13314, 13380, 22448, 13604, 13614, 13676, 13819, 14027, 14058, 14135, 14185, 14203, 14218, 14289, 14470, 14708, 14757, 15057, 15080, 15461, 15529, 15699, 15962, 16359, 16789, 22142, 22155, 22241, 17685, 17831, 17897, 17992, 18724, 22313, 18980, 22352, 19226, 19378, 19588, 19728, 19955, 20003, 20171, 20477, 20514, 20575, 21103, 20695, 20711, 20858, 20925, 23289, 23448, 23464, 23529, 23601, 23722, 23723, 23800, 24306, 24483, 24906, 25025, 25552, 25950, 26104, 26206, 26629, 26915, 27677, 27747, 27752, 27754, 27755, 27756, 27784, 27893, 28120, 29520, 29696, 29898, 29969, 30252, 30525, 30699, 30697, 30835, 30836, 30876, 31585, 31406, 31710)
17:48:00.623infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3853, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4455, 2148, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457))
17:48:00.627infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (7226, 1451, 1755, 773, 1282, 1300, 1524, 3135, 7362, 1522, 3569, 3675, 6033, 9005, 6276, 6707, 6761, 5271, 8957, 5861, 5872, 6135, 6912, 1529, 7201, 1822, 9824, 10586, 10631, 11383, 11849, 21132, 22137, 22034, 12487, 13817, 14690, 13241, 12978, 14139, 13685, 14158, 15312, 15474, 13167, 11886, 12453, 14474, 13345, 14676, 16348, 14188, 14167, 15658, 13818, 16347, 17472, 17895, 17635, 18862, 19585, 19273, 20000, 20210, 18741, 18892, 20449, 19680, 22670, 21688, 21625, 21450, 20371, 19980, 18893, 18720, 22562, 20546, 21308, 21134, 23131, 23438, 23436, 24930, 29617, 23648, 30871, 23771, 23789, 30268, 30186, 30082, 29895, 30695, 30696, 28021, 27758, 27759, 27658, 27308, 26741, 26549, 26100, 25845, 25704, 25547, 24970, 24348, 31532, 31656, 32175, 31575, 32533)
17:48:00.628infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3853, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4455, 2148, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457))
17:48:00.631infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (6034, 6277, 6708, 6762, 5320, 5868, 5873, 6136, 6913, 1577, 7202, 7227, 1562, 1847, 9921, 134, 1428, 1583, 1569, 1869, 5408, 22643, 11251, 11252, 11925, 12793, 12794, 12876, 13174, 13349, 13460, 22491, 13664, 22509, 14159, 14160, 21870, 14685, 14686, 14231, 14957, 14691, 14843, 15632, 15719, 15731, 16358, 16753, 22187, 22188, 17716, 17999, 18167, 19035, 19329, 19410, 19673, 19849, 20030, 20201, 20211, 20446, 20473, 22828, 20715, 20922, 20932, 21135, 23594, 23714, 24180, 24240, 24375, 24525, 25024, 25594, 26397, 26404, 26642, 27072, 28023, 28096, 28131, 30353)
17:48:00.635infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4486, 4349, 3916, 4480, 4481, 4484, 4433, 4248, 4235, 4257, 4291, 4285, 3598, 1756, 4324, 4323, 4373, 4055, 2534, 4112, 4106, 4144, 4016, 2739, 2765, 2777, 2742, 2776, 2737, 1186, 529, 2647, 2472, 2225, 3101, 786, 2589, 2672, 2662, 3112, 3151, 3250, 3235, 3232, 3247, 2658, 3249, 3300, 3327, 3363, 3392, 3364, 3348, 3388, 3415, 3384, 2865, 3470, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3661, 3703, 3725, 3853, 3755, 3746, 3763, 3803, 3935, 3857, 3997, 3967, 3900, 2599, 2812, 2878, 2783, 2981, 2756, 2963, 2708, 2817, 1842, 1843, 1558, 2141, 26, 1692, 1697, 1734, 1872, 655, 1930, 1934, 1946, 616, 656, 1091, 653, 2542, 798, 1177, 1702, 2340, 2349, 3724, 522, 4388, 4455, 2148, 4446, 4453, 4399, 4467, 4476, 4462, 4479, 4478, 4457))
17:48:00.637infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (11077, 11076, 12795, 14733, 15072, 23124, 18168, 18723, 31118)
17:48:00.638infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.644infoyii\db\Command::querySELECT "id", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (556, 533, 571, 676, 610, 4350, 826, 842, 1213, 3422, 3372, 1232, 2704, 3917, 1559, 1948, 1665, 1695, 1783, 2168, 800, 799, 2155, 2219, 3123, 3902, 3903, 3901, 2359, 2482, 1234, 2548, 2605, 3756, 2657, 2661, 2674, 2758, 2767, 2769, 2771, 2764, 2595, 2793, 2813, 2839, 2770, 2896, 3157, 2983, 4240, 2962, 3019, 3166, 3248, 3334, 3362, 3359, 3389, 3241, 3253, 3494, 3254, 3617, 3600, 3234, 4145, 3233, 4103, 3663, 3610, 3582, 3526, 3367, 3365, 3621, 675, 3403, 3503, 3574, 3466, 3704, 3726, 3727, 3863, 3804, 4376, 3747, 3773, 4118, 3769, 4374, 4295, 4293, 4250, 4122, 4136, 4056, 4098, 4017, 4000, 3969, 3936, 4447, 4463, 4475)
17:48:00.645infoyii\db\Command::querySELECT "id", "id" AS "key", "case_no", "project_id" FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (4175, 4174, 4173, 4172, 4171, 4170, 4169, 4168, 4167, 4166, 4164, 4161, 4158, 4157, 4155, 4152, 4151, 4150, 4144, 4142, 4127, 4111, 4098, 4096, 4086, 4079, 4078, 4063, 4057, 4052, 4014, 3991, 3950, 3949, 3927, 3899, 3886, 3874, 3872, 3857, 3855, 3816, 3813, 3786, 3767, 3764, 3760, 3752, 3751, 3744, 3723, 3714, 3686, 3679, 3661, 3660, 3653, 3652, 3644, 3633, 3623, 3599, 3591, 3590, 3589, 3577, 3576, 3568, 3552, 3544, 3515, 3514, 3513, 3503, 3467, 3458, 3441, 3424, 3372, 3371, 3318, 3300, 3281, 3276, 3274, 3269, 3265, 3263, 3251, 3246, 3235, 3225, 3216, 3209, 3208, 3201, 3195, 3157, 3148, 3073, 3027, 3019, 2939, 2907, 2893, 2759, 2695, 2684, 2530, 2508, 2507, 2504, 2459, 2458, 2422, 2080, 2079, 1983, 1963, 1938, 1929, 1925, 1791, 1460, 1240, 1111, 1018, 986, 983, 887, 884, 883, 861, 778, 764, 88)
17:48:00.649infoyii\db\Command::querySELECT "id", "case_id", "engineer_id", "assignment_status", "points", "percent" FROM "a57be577deb434"."tbl_case_assignments" WHERE "case_id" IN (4996, 4985, 4604, 4619, 5039, 5051, 4975, 4605, 4606, 5001, 5069, 5027, 2874, 2811, 4689, 2862, 4476, 4676, 5030, 2936, 4637, 2988, 2891, 3092, 4623, 4616, 4624, 3480, 4625, 4473, 2010, 2123, 2225, 2247, 2510, 2511, 2470, 2000, 2190, 4488, 2472, 2058, 2138, 2168, 2176, 2231, 2496, 2455, 2207, 2456, 2157, 2459, 2260, 2440, 2424, 2522, 2261, 2441, 2425, 2482, 2426, 2593, 2463, 2485, 2507, 2530, 1703, 2606, 2621, 2615, 2626, 2693, 2704, 2810, 2808, 2812, 2821, 2905, 2902, 2884, 2907, 2958, 2998, 3008, 3001, 3017, 3039, 3060, 3096, 3108, 2439, 3355, 4492, 2464, 3416, 2818, 3628, 3833, 5556, 5571, 6060, 6061, 6083, 6089, 6090, 6084, 6094, 6095, 6098, 6109, 6102, 6400, 6405, 6409, 6408, 6395, 6433, 6434, 6543, 6666, 6682, 6665, 6686, 6795, 6794, 6792, 6791, 6811, 6819, 6820, 6882, 6881, 6888, 6887, 6918, 6917, 6968, 6971, 7060, 7076, 7059, 7130, 8101, 9002, 9020, 9254, 9077, 9249, 9257, 9258, 9260) ORDER BY "assigned_at" DESC
17:48:00.655infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5064, 1015, 5085, 5248, 1022, 1023, 5296, 1001, 1016, 5125, 1020, 5074)