Total EGC Queries 11

No.QueryRowsSSError CodesTime (seconds)
1 SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' 0 Y Array ( [0] => 0 [1] => ) 0.0001109
2 SET time_zone = '+00:00' 0 Y Array ( [0] => 0 [1] => ) 0.0000851
3 SET NAMES UTF8 0 Y Array ( [0] => 0 [1] => ) 0.0001259
4 SELECT engineer_id, CONCAT_WS(" ", engineer_first_name, engineer_last_name) AS engineer_name, engineer_dash_order FROM engineer JOIN site_user su ON engineer.user_id = su.user_id WHERE (engineer_status = "OK") AND (su.user_status = "OK") ORDER BY engineer_dash_order 0 Y Array ( [0] => 0 [1] => ) 0.0003669
5 SELECT visit_customer_contact_role_id, visit_customer_contact_role_name, visit_customer_contact_role_status FROM visit_customer_contact_role ORDER BY visit_customer_contact_role_name ASC 0 Y Array ( [0] => 0 [1] => ) 0.0001872
6 SELECT service_id, service_name, service_status FROM service ORDER BY service_name ASC 0 Y Array ( [0] => 0 [1] => ) 0.0001960
7 SELECT customer_contact.customer_contact_id, CONCAT_WS(" - ", CONCAT_WS(" ", customer_contact.customer_contact_first_name, customer_contact.customer_contact_last_name ), customer.customer_name) AS customer_contact_name, customer_contact.customer_contact_status FROM customer_contact INNER JOIN customer ON customer_contact.customer_id = customer.customer_id ORDER BY customer_contact_name ASC 0 Y Array ( [0] => 0 [1] => ) 0.0060790
8 SELECT engineer_id, CONCAT_WS(" ", engineer_first_name, engineer_last_name ) AS engineer_name, engineer_status FROM engineer ORDER BY engineer_name ASC 0 Y Array ( [0] => 0 [1] => ) 0.0003631
9 SELECT j.job_id, c.customer_name, j.job_status FROM job AS j INNER JOIN customer AS c ON j.customer_id = c.customer_id ORDER BY j.job_id ASC 0 Y Array ( [0] => 0 [1] => ) 0.0551679
10 SELECT * FROM ls_inspection_report_questions 0 Y Array ( [0] => 0 [1] => ) 0.0003428
11 SELECT * FROM issue WHERE issue_status = "OK" 0 Y Array ( [0] => 0 [1] => ) 0.0001900
Total time: 0.0632148

Total PDO Queries 1

No.QueryRowsError CodesTime (seconds)
1SELECT setting_name, setting_value FROM customer_setting0Array ( [0] => 00000 [1] => [2] => ) 0.0012140
Total time: 0.0012140