Total EGC Queries 11

No.QueryRowsSSError CodesTime (seconds)
1 SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' 0 Y Array ( [0] => 0 [1] => ) 0.0004480
2 SET time_zone = '+00:00' 0 Y Array ( [0] => 0 [1] => ) 0.0004399
3 SET NAMES UTF8 0 Y Array ( [0] => 0 [1] => ) 0.0004389
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.0008042
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.0006640
6 SELECT service_id, service_name, service_status FROM service ORDER BY service_name ASC 0 Y Array ( [0] => 0 [1] => ) 0.0004251
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.0078959
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.0010152
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.0376589
10 SELECT * FROM ls_inspection_report_questions 0 Y Array ( [0] => 0 [1] => ) 0.0009599
11 SELECT * FROM issue WHERE issue_status = "OK" 0 Y Array ( [0] => 0 [1] => ) 0.0004611
Total time: 0.0512111