Total processing time: 130 ms; Peak memory: 6.444 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
15:07:45.022 | 19.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=982) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
15:07:45.049 | 15.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=982) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
15:07:44.946 | 2.7 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='lFICiryH6q1PKzl6ykU2iPsev0bYyy6d' |
15:07:44.967 | 2.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
15:07:44.944 | 1.8 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
15:07:44.996 | 1.5 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4082, '2025-08-11', '10667.4', 0.3, FALSE) RETURNING "id" |
15:07:44.950 | 1.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:07:45.006 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
15:07:45.017 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
15:07:45.042 | 1.2 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id" |
15:07:44.974 | 1.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3935, 1017, '0.6', 1001), (3935, 5085, '0.4', 1001) |
15:07:44.963 | 1.1 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3935, 4, '网络设备 ', '35558', 11, '3911.38') |
15:07:44.986 | 1.1 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='35558', "contract_type"=1, "save_collection_at"='now()' WHERE "id"=4082 |
15:07:45.021 | 1.1 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=982 |
15:07:45.069 | 1.1 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, NULL, NULL, 'v2/project/save-edit', '{"Projects":{"payment_collection_remind_ahead":"","bargain_date":"2025-08-11","client_id":"982","comment":"\u4eac\u6d25\u5180","contract_type":"1","from_contact":"4640","id":"3935","projectArchitects":{"1017":"0.6","5085":"0.4"},"projectProductTypes":{"4":{"budget":"35558","pct":"11"}},"projectRemindReceivers":["1001"],"project_progress":"9","project_status":"3","project_title":"\u5feb\u5feb\u5feb","purchaseType":"165","salesContractPaymentCollectionRemindDates":{"2025-08-11":"10667.4","2025-08-12":"24890.6"},"salesForecast":"181","used_client":""},"access_token":"lFICiryH6q1PKzl6ykU2iPsev0bYyy6d","device_type":"2","posttime":"1754896128","token":"332272f7ec0dc7c0e72ac368d3dd6695","version_code":"1148"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-08-11 15:07:45') RETURNING "id" |
15:07:44.966 | 1.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "client_id"=982, "project_status"=3, "project_progress"=9, "budget"='35558', "profit_pct"='11', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=4640 WHERE "id"=3935 |
15:07:45.064 | 1.0 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id" |
15:07:44.977 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 165, 3935) |
15:07:44.984 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3935 |
15:07:44.970 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3935, 'a:0:{}', '', 1001, '223.104.41.5') |
15:07:44.991 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'salesContractPaymentCollectionRemindDates', 3935, 1, 1001, 'now()', '[["2025-08-12 24890.6\u5143","2025-08-14 22\u5143"]]', '[["2025-08-12 24890.6\u5143","2025-08-14 22\u5143"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u8ba1\u5212","d4":["2025-08-12 24890.6\u5143;2025-08-14 22\u5143; <b>\u53d8\u4e3a<\/b> 2025-08-12 24890.6\u5143;2025-08-14 22\u5143;"]}') |
15:07:44.982 | 0.9 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3935, 1001) RETURNING "id" |
15:07:45.007 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3935, 'a:1:{s:14:"collected_plan";s:7:"35558.0";}', '', 1001, '223.104.41.5') |
15:07:44.994 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'salesContractPaymentCollectionRemindDates', 3935, 1, 1001, 'now()', '[["2025-08-12 24890.6\u5143","2025-08-14 22\u5143"]]', '[["2025-08-12 24890.6\u5143","2025-08-14 22\u5143"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6536\u6b3e\u8ba1\u5212","d4":["2025-08-12 24890.6\u5143;2025-08-14 22\u5143; <b>\u53d8\u4e3a<\/b> 2025-08-12 24890.6\u5143;2025-08-14 22\u5143;"]}') |
15:07:44.961 | 0.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3935 |
15:07:45.045 | 0.8 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 982, 10, 3935, 1, 1001, '[3935]', '[3935]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u5feb\u5feb\u5feb"]}') RETURNING "id" |
15:07:45.005 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected_plan"='35558.0' WHERE "id"=3935 |
15:07:45.016 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3935 |
15:07:44.989 | 0.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1) |
15:07:44.952 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3935' |
15:07:44.998 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesContractPaymentCollectionRemindDates', 2556, 'a:9:{s:2:"id";i:2556;s:11:"contract_id";i:4082;s:11:"remind_date";s:10:"2025-08-11";s:8:"reminded";b:0;s:6:"amount";d:10667.4;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";d:0.29999999999999999;}', '', 1001, '223.104.41.5') |
15:07:45.013 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='35558' WHERE "id"=4082 |
15:07:45.003 | 0.8 ms | yii\db\Command::query | SELECT r.amount, t.created_at 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
15:07:44.987 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4082, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1001, '223.104.41.5') |
15:07:45.010 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
15:07:45.043 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 177477, 'a:5:{s:2:"id";i:177477;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '223.104.41.5') |
15:07:44.983 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectRemindReceivers', 1703, 'a:3:{s:2:"id";i:1703;s:10:"project_id";i:3935;s:7:"user_id";s:4:"1001";}', '', 1001, '223.104.41.5') |
15:07:44.980 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 181, 3935) |
15:07:44.999 | 0.7 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4082, '2025-08-12', '24890.6', 0.7, FALSE) RETURNING "id" |
15:07:45.066 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 177478, 'a:5:{s:2:"id";i:177478;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '223.104.41.5') |
15:07:45.000 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesContractPaymentCollectionRemindDates', 2557, 'a:9:{s:2:"id";i:2557;s:11:"contract_id";i:4082;s:11:"remind_date";s:10:"2025-08-12";s:8:"reminded";b:0;s:6:"amount";d:24890.599999999999;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";d:0.69999999999999996;}', '', 1001, '223.104.41.5') |
15:07:45.001 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4082 |
15:07:44.977 | 0.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3935) AND ("term_id"=9) |
15:07:44.973 | 0.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3935 |
15:07:45.019 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3935, 'a:0:{}', '', 1001, '223.104.41.5') |
15:07:45.014 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4082, 'a:0:{}', '', 1001, '223.104.41.5') |
15:07:44.995 | 0.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4082 |
15:07:45.044 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 982, 'a:0:{}', '', 1001, '223.104.41.5') |
15:07:45.066 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 982, 'a:0:{}', '', 1001, '223.104.41.5') |
15:07:45.046 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 552160, 'a:13:{s:2:"id";i:552160;s:9:"object_id";s:3:"982";s:11:"object_type";i:10;s:9:"target_id";i:3935;s:18:"target_object_type";i:1;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[3935]";s:9:"new_value";s:6:"[3935]";s:11:"description";s:101:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["\u5feb\u5feb\u5feb"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.104.41.5') |
15:07:44.981 | 0.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3935 |
15:07:44.979 | 0.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3935) AND ("term_id"=13) |
15:07:44.956 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (2, 165, 181, 184, 189, 349)) ORDER BY "sort" |
15:07:45.002 | 0.6 ms | yii\db\Command::query | SELECT r.amount, t.created_at 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
15:07:44.971 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982' |
15:07:44.985 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3935) |
15:07:45.068 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3935) |
15:07:44.961 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3935 |
15:07:44.958 | 0.5 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982') |
15:07:45.012 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT "r".* 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"=4082) AND ("t"."status"=1)) |
15:07:45.010 | 0.4 ms | yii\db\Command::query | SELECT SUM(r.amount) 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
15:07:44.955 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3935 |
15:07:45.012 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT "r".* 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"=4082) AND ("t"."status"=1)) |
15:07:44.957 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='982') AND ("project_title"='快快快') AND ("id" != 3935)) |
15:07:44.990 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4082 |
15:07:45.048 | 0.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2025-01-01 00:00:00') AND ("bargain_date" <= '2025-12-31 23:59:59') AND ("client_id"=982) |
15:07:44.972 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3935 |
15:07:45.045 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:07:44.960 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='4640') |
15:07:44.962 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4 |
15:07:45.047 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982' |
15:07:44.992 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982' |
15:07:44.958 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
15:07:44.965 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:07:44.972 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:07:45.008 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
15:07:45.015 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
15:07:44.988 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
15:07:44.964 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:07:44.991 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:07:45.068 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
15:07:45.004 | 0.3 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4082 |
15:07:45.020 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
15:07:45.009 | 0.3 ms | yii\db\Command::query | SELECT SUM(r.amount) 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"=4082) AND ("t"."status" IN (2, 5, 1)) |
15:07:44.993 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
15:07:44.981 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3935 |
15:07:45.020 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982' |
15:07:45.011 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT "r".* 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"=4082) AND ("t"."status"=1)) |
15:07:44.959 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='9') |
15:07:45.015 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
15:07:44.976 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (2, 165, 181, 184, 189, 349)) ORDER BY "sort" |
15:07:45.004 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
15:07:45.009 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082 |
15:07:44.996 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082) |
15:07:44.959 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='3') |
15:07:44.989 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
15:07:45.001 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082 |
15:07:45.015 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
15:07:44.960 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
15:07:44.999 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082) |
15:07:44.975 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3935 |
15:07:44.976 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=165 |
15:07:44.979 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=181 |
15:07:44.979 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='181' |
15:07:44.976 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='165' |