Total EGC Queries 12

No.QueryRowsSSError CodesTime (seconds)
1 SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' 0 Y Array ( [0] => 0 [1] => ) 0.0005951
2 SET time_zone = '+01:00' 0 Y Array ( [0] => 0 [1] => ) 0.0004721
3 SET NAMES utf8mb4 0 Y Array ( [0] => 0 [1] => ) 0.0005431
4 SET NAMES UTF8 0 Y Array ( [0] => 0 [1] => ) 0.0005350
5 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.0007808
6 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.0006590
7 SELECT service_id, service_name, service_status FROM service ORDER BY service_name ASC 0 Y Array ( [0] => 0 [1] => ) 0.0006781
8 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.0069680
9 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.0008051
10 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.0348542
11 SELECT * FROM ls_inspection_report_questions 0 Y Array ( [0] => 0 [1] => ) 0.0007889
12 SELECT * FROM issue WHERE issue_status = "OK" 0 Y Array ( [0] => 0 [1] => ) 0.0006690
Total time: 0.0483484

Total PDO Queries 1

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