Query Metrics
48
Database Queries
9
Different statements
27.17 ms
Query time
5
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.60 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.username AS username_4, t0.password AS password_5, t0.remember_token AS remember_token_6, t0.role AS role_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t11.id AS id_12, t11.phone_number AS phone_number_13, t11.address1 AS address1_14, t11.address2 AS address2_15, t11.address3 AS address3_16, t11.address4 AS address4_17, t11.postcode AS postcode_18, t11.latitude AS latitude_19, t11.longitude AS longitude_20, t11.created_at AS created_at_21, t11.updated_at AS updated_at_22, t11.deleted_at AS deleted_at_23, t11.user_id AS user_id_24 FROM user t0 LEFT JOIN employee t11 ON t11.user_id = t0.id WHERE t0.username = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"[email protected]"
]
|
2 | 1.31 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.job_id AS job_id_5, t0.user_id AS user_id_6 FROM job_status_log t0 WHERE t0.user_id = ?
Parameters:
[
1
]
|
3 | 2.46 ms |
SELECT c0_.id AS id_0, c0_.email AS email_1, c0_.first_name AS first_name_2, c0_.last_name AS last_name_3, c0_.phone_number AS phone_number_4, c0_.consent_to_marketing AS consent_to_marketing_5, c0_.communication_preference AS communication_preference_6, c0_.notes AS notes_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.deleted_at AS deleted_at_10 FROM customer c0_ WHERE (c0_.deleted_at IS NULL) ORDER BY c0_.first_name ASC LIMIT 10
Parameters:
[] |
4 | 0.61 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
148
]
|
5 | 0.44 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
147
]
|
6 | 1.01 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
147
]
|
7 | 0.83 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
148
]
|
8 | 0.62 ms |
SELECT t0.id AS id_1, t0.message AS message_2, t0.subject AS subject_3, t0.recipient_count AS recipient_count_4, t0.sensitive_content AS sensitive_content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.job_id AS job_id_8, t0.sender_id AS sender_id_9, t10.id AS id_11, t10.created_at AS created_at_12, t10.updated_at AS updated_at_13, t10.deleted_at AS deleted_at_14, t10.message_id AS message_id_15, t10.service_campaign_id AS service_campaign_id_16 FROM message t0 LEFT JOIN service_campaign_message t10 ON t10.message_id = t0.id WHERE t0.id = ?
Parameters:
[
29
]
|
9 | 0.63 ms |
SELECT t0.id AS id_1, t0.message AS message_2, t0.subject AS subject_3, t0.recipient_count AS recipient_count_4, t0.sensitive_content AS sensitive_content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.job_id AS job_id_8, t0.sender_id AS sender_id_9, t10.id AS id_11, t10.created_at AS created_at_12, t10.updated_at AS updated_at_13, t10.deleted_at AS deleted_at_14, t10.message_id AS message_id_15, t10.service_campaign_id AS service_campaign_id_16 FROM message t0 LEFT JOIN service_campaign_message t10 ON t10.message_id = t0.id WHERE t0.id = ?
Parameters:
[
30
]
|
10 | 0.42 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
150
]
|
11 | 0.32 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
149
]
|
12 | 0.48 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
149
]
|
13 | 0.44 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
150
]
|
14 | 0.38 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1324
]
|
15 | 0.31 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1318
]
|
16 | 0.62 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1318
]
|
17 | 0.53 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
1324
]
|
18 | 0.40 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1127
]
|
19 | 0.51 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1121
]
|
20 | 0.47 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1121
]
|
21 | 0.58 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
1127
]
|
22 | 0.36 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
790
]
|
23 | 0.34 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
788
]
|
24 | 0.55 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
788
]
|
25 | 0.32 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
790
]
|
26 | 0.54 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
151
]
|
27 | 0.31 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
150
]
|
28 | 0.40 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
150
]
|
29 | 0.39 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
151
]
|
30 | 0.40 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
925
]
|
31 | 0.32 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
923
]
|
32 | 0.61 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
923
]
|
33 | 0.52 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
925
]
|
34 | 0.37 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
538
]
|
35 | 0.56 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
537
]
|
36 | 0.49 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
537
]
|
37 | 0.35 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
538
]
|
38 | 0.33 ms |
SELECT t0.id AS id_1, t0.message AS message_2, t0.subject AS subject_3, t0.recipient_count AS recipient_count_4, t0.sensitive_content AS sensitive_content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.job_id AS job_id_8, t0.sender_id AS sender_id_9, t10.id AS id_11, t10.created_at AS created_at_12, t10.updated_at AS updated_at_13, t10.deleted_at AS deleted_at_14, t10.message_id AS message_id_15, t10.service_campaign_id AS service_campaign_id_16 FROM message t0 LEFT JOIN service_campaign_message t10 ON t10.message_id = t0.id WHERE t0.id = ?
Parameters:
[
548
]
|
39 | 0.34 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
152
]
|
40 | 0.54 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
151
]
|
41 | 0.72 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
151
]
|
42 | 0.35 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
152
]
|
43 | 0.42 ms |
SELECT t0.id AS id_1, t0.message AS message_2, t0.subject AS subject_3, t0.recipient_count AS recipient_count_4, t0.sensitive_content AS sensitive_content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.job_id AS job_id_8, t0.sender_id AS sender_id_9, t10.id AS id_11, t10.created_at AS created_at_12, t10.updated_at AS updated_at_13, t10.deleted_at AS deleted_at_14, t10.message_id AS message_id_15, t10.service_campaign_id AS service_campaign_id_16 FROM message t0 LEFT JOIN service_campaign_message t10 ON t10.message_id = t0.id WHERE t0.id = ?
Parameters:
[
287
]
|
44 | 0.36 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.address1 AS address1_3, t0.address2 AS address2_4, t0.address3 AS address3_5, t0.address4 AS address4_6, t0.postcode AS postcode_7, t0.notes AS notes_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.materials AS materials_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.customer_id AS customer_id_15 FROM pond t0 WHERE t0.customer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1030
]
|
45 | 0.30 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.pond_id AS pond_id_6 FROM pond_image t0 WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1026
]
|
46 | 0.48 ms |
SELECT t0.id AS id_1, t0.notes AS notes_2, t0.price AS price_3, t0.estimated_duration AS estimated_duration_4, t0.status AS status_5, t0.priority AS priority_6, t0.schedule_date AS schedule_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.pond_id AS pond_id_11, t0.service_id AS service_id_12, t13.id AS id_14, t13.quantity AS quantity_15, t13.quantity_used AS quantity_used_16, t13.created_at AS created_at_17, t13.updated_at AS updated_at_18, t13.deleted_at AS deleted_at_19, t13.material_id AS material_id_20, t13.job_id AS job_id_21, t22.id AS id_23, t22.status AS status_24, t22.created_at AS created_at_25, t22.updated_at AS updated_at_26, t22.job_id AS job_id_27, t22.user_id AS user_id_28 FROM job t0 LEFT JOIN job_material t13 ON t13.job_id = t0.id LEFT JOIN job_status_log t22 ON t22.job_id = t0.id WHERE t0.pond_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1026
]
|
47 | 0.50 ms |
SELECT t0.id AS id_1, t0.message_type AS message_type_2, t0.message_status AS message_status_3, t0.reason_failed AS reason_failed_4, t0.reply_message AS reply_message_5, t0.reply_type AS reply_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.customer_id AS customer_id_9, t0.user_id AS user_id_10, t0.employee_id AS employee_id_11, t0.message_id AS message_id_12 FROM message_log t0 WHERE t0.customer_id = ?
Parameters:
[
1030
]
|
48 | 1.02 ms |
SELECT count(c0_.id) AS sclr_0 FROM customer c0_ WHERE (c0_.deleted_at IS NULL)
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Customer | No errors. |
App\Entity\User | No errors. |
App\Entity\Employee | No errors. |
App\Entity\MessageLog | No errors. |
App\Entity\JobStatusLog | No errors. |
App\Entity\Job |
|
App\Entity\Message | No errors. |
App\Entity\Pond | No errors. |
App\Entity\PondImage | No errors. |
App\Entity\JobImage | No errors. |
App\Entity\Service | No errors. |
App\Entity\ServiceCampaign |
|
App\Entity\ServiceCampaignRecipient | No errors. |
App\Entity\StaffAvailability | No errors. |
App\Entity\TimeOff | No errors. |
App\Entity\Schedule | No errors. |
App\Entity\JobMaterial |
|
App\Entity\Material |
|
App\Entity\ServiceCampaignMessage |
|