https://portal.pondsnorthwest.com/customers?itemsPerPage=10&order%5BfirstName%5D=asc

Query Metrics

48 Database Queries
9 Different statements
27.17 ms Query time
5 Invalid entities

Queries

Group similar statements

# 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
  • The mappings App\Entity\Job#jobMaterials and App\Entity\JobMaterial#job are inconsistent with each other.
  • The field App\Entity\Job#schedules is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Schedule#job does not contain the required 'inversedBy="schedules"' attribute.
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
  • The mappings App\Entity\ServiceCampaign#serviceCampaignMessages and App\Entity\ServiceCampaignMessage#serviceCampaign are inconsistent with each other.
App\Entity\ServiceCampaignRecipient No errors.
App\Entity\StaffAvailability No errors.
App\Entity\TimeOff No errors.
App\Entity\Schedule No errors.
App\Entity\JobMaterial
  • The association App\Entity\JobMaterial#material refers to the inverse side field App\Entity\Material#jobMaterial which does not exist.
  • The association App\Entity\JobMaterial#job refers to the inverse side field App\Entity\Job#jobMaterial which does not exist.
App\Entity\Material
  • The mappings App\Entity\Material#jobMaterials and App\Entity\JobMaterial#material are inconsistent with each other.
App\Entity\ServiceCampaignMessage
  • The association App\Entity\ServiceCampaignMessage#serviceCampaign refers to the inverse side field App\Entity\ServiceCampaign#serviceCampaignMessage which does not exist.