Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.civility AS civility_2,
  t0.image AS image_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.phone AS phone_6,
  t0.cgv AS cgv_7,
  t0.email AS email_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.stripe_customer_id AS stripe_customer_id_11,
  t0.sage_customer_id AS sage_customer_id_12,
  t0.social_reason AS social_reason_13,
  t0.neofleet AS neofleet_14,
  t0.channel AS channel_15,
  t0.position AS position_16,
  t0.admin AS admin_17,
  t0.renewability_thresholds AS renewability_thresholds_18,
  t0.neoplaque_config AS neoplaque_config_19,
  t0.business_central_id AS business_central_id_20,
  t0.business_central_num AS business_central_num_21,
  t0.deleted_at AS deleted_at_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.status_id AS status_id_25,
  t0.job_id AS job_id_26,
  t0.sector_id AS sector_id_27,
  t0.usage_id AS usage_id_28,
  t0.company_id AS company_id_29,
  t30.id AS id_31,
  t30.sage_company_id AS sage_company_id_32,
  t30.stripe_customer_id AS stripe_customer_id_33,
  t30.name AS name_34,
  t30.name_complement AS name_complement_35,
  t30.phone AS phone_36,
  t30.accountancy_emails AS accountancy_emails_37,
  t30.siret AS siret_38,
  t30.customer_code AS customer_code_39,
  t30.vat_rate AS vat_rate_40,
  t30.channel AS channel_41,
  t30.address AS address_42,
  t30.bad_payer AS bad_payer_43,
  t30.accountant_email AS accountant_email_44,
  t30.business_central_id AS business_central_id_45,
  t30.business_central_num AS business_central_num_46,
  t30.deleted_at AS deleted_at_47,
  t30.created_at AS created_at_48,
  t30.updated_at AS updated_at_49,
  t30.payment_methods_allowed_methods AS payment_methods_allowed_methods_50,
  t30.payment_limits_limits AS payment_limits_limits_51,
  t30.owner_id AS owner_id_52,
  t30.sector_id AS sector_id_53,
  t30.status_id AS status_id_54
FROM
  "user" t0
  LEFT JOIN company t30 ON t30.owner_id = t0.id
WHERE
  t0.email = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.civility AS civility_2, t0.image AS image_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.phone AS phone_6, t0.cgv AS cgv_7, t0.email AS email_8, t0.password AS password_9, t0.roles AS roles_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.sage_customer_id AS sage_customer_id_12, t0.social_reason AS social_reason_13, t0.neofleet AS neofleet_14, t0.channel AS channel_15, t0.position AS position_16, t0.admin AS admin_17, t0.renewability_thresholds AS renewability_thresholds_18, t0.neoplaque_config AS neoplaque_config_19, t0.business_central_id AS business_central_id_20, t0.business_central_num AS business_central_num_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.status_id AS status_id_25, t0.job_id AS job_id_26, t0.sector_id AS sector_id_27, t0.usage_id AS usage_id_28, t0.company_id AS company_id_29, t30.id AS id_31, t30.sage_company_id AS sage_company_id_32, t30.stripe_customer_id AS stripe_customer_id_33, t30.name AS name_34, t30.name_complement AS name_complement_35, t30.phone AS phone_36, t30.accountancy_emails AS accountancy_emails_37, t30.siret AS siret_38, t30.customer_code AS customer_code_39, t30.vat_rate AS vat_rate_40, t30.channel AS channel_41, t30.address AS address_42, t30.bad_payer AS bad_payer_43, t30.accountant_email AS accountant_email_44, t30.business_central_id AS business_central_id_45, t30.business_central_num AS business_central_num_46, t30.deleted_at AS deleted_at_47, t30.created_at AS created_at_48, t30.updated_at AS updated_at_49, t30.payment_methods_allowed_methods AS payment_methods_allowed_methods_50, t30.payment_limits_limits AS payment_limits_limits_51, t30.owner_id AS owner_id_52, t30.sector_id AS sector_id_53, t30.status_id AS status_id_54 FROM "user" t0 LEFT JOIN company t30 ON t30.owner_id = t0.id WHERE t0.email = 'jblondeau@dataneo.fr' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.area AS area_3,
  t0.description AS description_4,
  t0.zc_custom AS zc_custom_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.company_id AS company_id_9,
  t0.brand_id AS brand_id_10,
  t0.status_id AS status_id_11
FROM
  dealership t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.area AS area_3, t0.description AS description_4, t0.zc_custom AS zc_custom_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.company_id AS company_id_9, t0.brand_id AS brand_id_10, t0.status_id AS status_id_11 FROM dealership t0 WHERE t0.id = '1ee950cc-2fd8-67bc-ad7b-03163a0bc151' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.employee_id AS employee_id_2,
  t0.role_id AS role_id_3,
  t0.dealership_id AS dealership_id_4,
  t0.subscription_licence_id AS subscription_licence_id_5
FROM
  user_dealership t0
WHERE
  t0.dealership_id = ?

SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.role_id AS role_id_3, t0.dealership_id AS dealership_id_4, t0.subscription_licence_id AS subscription_licence_id_5 FROM user_dealership t0 WHERE t0.dealership_id = '1ee950cc-2fd8-67bc-ad7b-03163a0bc151';

SELECT
  t0.id AS id_1,
  t0.field AS field_2,
  t0.code AS code_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.comment AS comment_6,
  t0.value AS value_7,
  t0.position AS position_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.parent_code_id AS parent_code_id_12
FROM
  code t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.field AS field_2, t0.code AS code_3, t0.title AS title_4, t0.description AS description_5, t0.comment AS comment_6, t0.value AS value_7, t0.position AS position_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_code_id AS parent_code_id_12 FROM code t0 WHERE t0.id = '1ec41710-58be-6df4-90be-4326b70135fd' AND ((t0.deleted_at IS NULL));

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  spot_contact s0_
  LEFT JOIN "user" u1_ ON s0_.owner_id = u1_.id
WHERE
  (s0_.spot = ?)
  AND (
    s0_.dealership_id = '1ee950cc-2fd8-67bc-ad7b-03163a0bc151'
  )

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM spot_contact s0_ LEFT JOIN "user" u1_ ON s0_.owner_id = u1_.id WHERE (s0_.spot = '38012986648625') AND (s0_.dealership_id = '1ee950cc-2fd8-67bc-ad7b-03163a0bc151');

SELECT
  s0_.id AS id_0,
  s0_.spot AS spot_1,
  s0_.id_pers AS id_pers_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  u1_.id AS id_5,
  u1_.civility AS civility_6,
  u1_.image AS image_7,
  u1_.firstname AS firstname_8,
  u1_.lastname AS lastname_9,
  u1_.phone AS phone_10,
  u1_.cgv AS cgv_11,
  u1_.email AS email_12,
  u1_.password AS password_13,
  u1_.roles AS roles_14,
  u1_.stripe_customer_id AS stripe_customer_id_15,
  u1_.sage_customer_id AS sage_customer_id_16,
  u1_.social_reason AS social_reason_17,
  u1_.neofleet AS neofleet_18,
  u1_.channel AS channel_19,
  u1_.position AS position_20,
  u1_.admin AS admin_21,
  u1_.renewability_thresholds AS renewability_thresholds_22,
  u1_.neoplaque_config AS neoplaque_config_23,
  u1_.business_central_id AS business_central_id_24,
  u1_.business_central_num AS business_central_num_25,
  u1_.deleted_at AS deleted_at_26,
  u1_.created_at AS created_at_27,
  u1_.updated_at AS updated_at_28,
  s0_.dealership_id AS dealership_id_29,
  s0_.owner_id AS owner_id_30,
  u1_.status_id AS status_id_31,
  u1_.job_id AS job_id_32,
  u1_.sector_id AS sector_id_33,
  u1_.usage_id AS usage_id_34,
  u1_.company_id AS company_id_35
FROM
  spot_contact s0_
  LEFT JOIN "user" u1_ ON s0_.owner_id = u1_.id
WHERE
  (s0_.spot = ?)
  AND (
    s0_.dealership_id = '1ee950cc-2fd8-67bc-ad7b-03163a0bc151'
  )
ORDER BY
  s0_.updated_at DESC
LIMIT
  30

SELECT s0_.id AS id_0, s0_.spot AS spot_1, s0_.id_pers AS id_pers_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, u1_.id AS id_5, u1_.civility AS civility_6, u1_.image AS image_7, u1_.firstname AS firstname_8, u1_.lastname AS lastname_9, u1_.phone AS phone_10, u1_.cgv AS cgv_11, u1_.email AS email_12, u1_.password AS password_13, u1_.roles AS roles_14, u1_.stripe_customer_id AS stripe_customer_id_15, u1_.sage_customer_id AS sage_customer_id_16, u1_.social_reason AS social_reason_17, u1_.neofleet AS neofleet_18, u1_.channel AS channel_19, u1_.position AS position_20, u1_.admin AS admin_21, u1_.renewability_thresholds AS renewability_thresholds_22, u1_.neoplaque_config AS neoplaque_config_23, u1_.business_central_id AS business_central_id_24, u1_.business_central_num AS business_central_num_25, u1_.deleted_at AS deleted_at_26, u1_.created_at AS created_at_27, u1_.updated_at AS updated_at_28, s0_.dealership_id AS dealership_id_29, s0_.owner_id AS owner_id_30, u1_.status_id AS status_id_31, u1_.job_id AS job_id_32, u1_.sector_id AS sector_id_33, u1_.usage_id AS usage_id_34, u1_.company_id AS company_id_35 FROM spot_contact s0_ LEFT JOIN "user" u1_ ON s0_.owner_id = u1_.id WHERE (s0_.spot = '38012986648625') AND (s0_.dealership_id = '1ee950cc-2fd8-67bc-ad7b-03163a0bc151') ORDER BY s0_.updated_at DESC LIMIT 30;