Symfony Profiler

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)
  )

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 = 147 AND ((t0.deleted_at IS NULL));

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 = ?

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 = 148;

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)
  )

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 = 148 AND ((t0.deleted_at IS NULL));

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)
  )

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 = 147 AND ((t0.deleted_at IS NULL));

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

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;

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 = ?

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 = 29;

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

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 = '[email protected]' AND ((t0.deleted_at IS NULL)) LIMIT 1;

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 = ?

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 = 1;

SELECT
  count(c0_.id) AS sclr_0
FROM
  customer c0_
WHERE
  (c0_.deleted_at IS NULL)

SELECT count(c0_.id) AS sclr_0 FROM customer c0_ WHERE (c0_.deleted_at IS NULL);