ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1d1f754394a: POST https://beta.jinchangxiao.com/vue/project/list-all-status at 2026-06-01 01:58:13 pm by 43.224.72.82

Database Queries

总计31条数据
TimeDurationTypeQuery
  
13:58:13.2811.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5495

[+] Explain
13:58:13.2840.6 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495

[+] Explain
13:58:13.2945.7 msSELECTSELECT COUNT(*) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3015.9 msSELECTSELECT COUNT(*) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3105.1 msSELECTSELECT SUM(budget) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3167.4 msSELECTSELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
13:58:13.3245.2 msSELECTSELECT COUNT(*) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3294.9 msSELECTSELECT SUM(budget) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3357.2 msSELECTSELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
13:58:13.3425.1 msSELECTSELECT COUNT(*) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3485.3 msSELECTSELECT SUM(budget) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3537.0 msSELECTSELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
13:58:13.3610.3 msSELECTSELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1

[+] Explain
13:58:13.3610.4 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1

[+] Explain
13:58:13.3620.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493

[+] Explain
13:58:13.3620.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)

[+] Explain
13:58:13.3630.2 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" WHERE "object_id"=1

[+] Explain
13:58:13.3630.6 msSELECTSELECT "id", "id" AS "key", "name", "description" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (61, 162, 2100000000, 71, 93)) ORDER BY "sort"

[+] Explain
13:58:13.3640.2 msSELECTSELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "o6a13e2c574d5a"."tbl_project_statuses" WHERE "id"=3

[+] Explain
13:58:13.3640.2 msSELECTSELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "o6a13e2c574d5a"."tbl_project_progresses" WHERE "id"=6

[+] Explain
13:58:13.3650.2 msSELECTSELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "o6a13e2c574d5a"."tbl_project_remind_receivers" WHERE "project_id"=1

[+] Explain
13:58:13.3654.5 msSELECTSELECT COUNT(*) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3714.6 msSELECTSELECT SUM(budget) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3806.4 msSELECTSELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
13:58:13.3873.5 msSELECTSELECT COUNT(*) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3934.9 msSELECTSELECT SUM(budget) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.3986.5 msSELECTSELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
13:58:13.4054.7 msSELECTSELECT COUNT(*) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.4105.1 msSELECTSELECT SUM(budget) FROM (SELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"

[+] Explain
13:58:13.4166.8 msSELECTSELECT 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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."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"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20

[+] Explain
13:58:13.4242.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/project/list-all-status', '{"ProjectSearch":{"group":"","project_status":"","creator":"","purchaseType":"","engineer_group":"","period":"","budget":"","profit_pct":"","invoice_status":"","payment_status":"","collected_plan":"","project_progress":"","salesForecast":"","projectProductTypes":"","contact_point_status":"","from_contact_name":"","from_contact":"","contract_type":"","is_sales_order_ready":"","created_period":""},"Filter":{"name":"bargain_date","sort":"DESC","Tsort":"","Tname":""},"page":"1","web_access_token":"BVNSh9YfxWIaBBEpqELLGqJuWOoESJvj"}', '{"code":2000,"result":{"list1count":0,"list1sum":"","list1":[],"list2count":0,"list2sum":"","list2":[],"list3count":1,"list3sum":"10000","list3":[{"id":1,"client_id":1,"project_status":3,"project_progress":6,"budget":"10000","profit_pct":"60","bargain_date":"2026-05-27","description":"","created_by":5493,"created_at":"2026-05-27 17:25:00","updated_at":"2026-05-27 17:32:47","engineer_id":"","project_title":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260527001","collected":"0","status_updated_at":"2026-05-27 17:26:48.428905+08","success_rate":"","comment":"\u6d4b\u8bd5\u9500\u552e\u5408\u540c\u64cd\u4f5c","contract_type":1,"progress_updated_at":"2026-05-27 17:26:48.428905+08","forecast_updated_at":"2026-05-27 17:26:48.428905+08","end_at":"","pinyin_shortcut":"xsxssc20260527001","creator":5495,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":1,"is_sales_order_ready":false,"collected_plan":"10000","change_status_to":"","is_verify":false,"profits":"6000.0000000000000000","remain":"4 days 20:31:24.926482","progress_remain":"4 days 20:31:24.926482","forecast_remain":"4 days 20:31:24.926482","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"4 days 20:33:12.902359","issued_invoices":"","client":{"id":1,"key":1,"name":"\u903b\u8f91\u6d4b\u8bd5-\u9500\u552e\u5408\u540c","logo":"","client_type":1,"client_class":1,"client_industry":20,"sales_rep":5493},"usedClient":{},"salesRep":{"id":5493,"key":5493,"name":"97289742","sex":"M","avatar":{}},"salesForecast":{"id":93,"key":93,"name":"\u786e\u4fdd","description":"100%\u786e\u8ba4\u5728\u6210\u4ea4\u65e5\u671f\u5185\u7b7e\u8ba2\u5408\u540c\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002\n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u7248\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_update":false,"can_delete":false}],"list4count":0,"list4sum":"","list4":[],"list5count":0,"list5sum":"","list5":[],"list6count":0,"list6sum":"","list6":[],"thisUser":"","can_create":false,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 13:58:13', 145900800) RETURNING "id"

[+] Explain