Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.tax AS tax_3,
  t0.reference_eloa AS reference_eloa_4,
  t0.label AS label_5
FROM
  country t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.code = 'nl' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.multi_caster_id AS multi_caster_id_4,
  t0.telephone AS telephone_5,
  t0.siret AS siret_6,
  t0.is_active AS is_active_7,
  t0.eloa_ref AS eloa_ref_8,
  t0.eloa_last_check AS eloa_last_check_9,
  t0.eloa_statut AS eloa_statut_10,
  t0.libelle AS libelle_11,
  t0.reference_entite AS reference_entite_12,
  t0.raison_sociale AS raison_sociale_13,
  t0.ref_type_reseau AS ref_type_reseau_14,
  t0.orias AS orias_15,
  t0.description AS description_16,
  t0.has_grey_card_service AS has_grey_card_service_17,
  t0.slug AS slug_18,
  t0.has_loyalty_program AS has_loyalty_program_19,
  t0.has_up_my_shop AS has_up_my_shop_20,
  t0.latitude AS latitude_21,
  t0.longitude AS longitude_22,
  t0.royalty_network_date AS royalty_network_date_23,
  t0.royalty_remainder AS royalty_remainder_24,
  t0.fiscal_code_it AS fiscal_code_it_25,
  t0.leocare_id AS leocare_id_26,
  t0.autoscout24_api_id AS autoscout24_api_id_27,
  t0.up_my_shop_url AS up_my_shop_url_28,
  t0.lacentrale_id AS lacentrale_id_29,
  t0.has_annoncesautomobile AS has_annoncesautomobile_30,
  t0.definitively_inactive AS definitively_inactive_31,
  t0.first_contract_date AS first_contract_date_32,
  t0.opening_date AS opening_date_33,
  t0.vosfactures_id AS vosfactures_id_34,
  t0.vosfactures_client_id AS vosfactures_client_id_35,
  t0.grey_card_website AS grey_card_website_36,
  t0.has_cps AS has_cps_37,
  t0.contract_date AS contract_date_38,
  t0.autoscout24_id AS autoscout24_id_39,
  t0.paruvendu_id AS paruvendu_id_40,
  t0.ouestfrance_id AS ouestfrance_id_41,
  t0.atoutcoin_id AS atoutcoin_id_42,
  t0.royalty_variable_date AS royalty_variable_date_43,
  t0.royalty_communication_date AS royalty_communication_date_44,
  t0.agency_migrated AS agency_migrated_45,
  t0.facturation_id AS facturation_id_46,
  t0.invoice_number AS invoice_number_47,
  t0.address_number AS address_number_48,
  t0.address_extension AS address_extension_49,
  t0.address_street AS address_street_50,
  t0.address AS address_51,
  t0.created_at AS created_at_52,
  t0.updated_at AS updated_at_53,
  t0.city_id AS city_id_54,
  t0.company_id AS company_id_55,
  t0.royalty_network_id AS royalty_network_id_56,
  t0.royalty_communication_id AS royalty_communication_id_57,
  t0.royalty_variable_id AS royalty_variable_id_58,
  t0.close_reason_id AS close_reason_id_59
FROM
  agency t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.multi_caster_id AS multi_caster_id_4, t0.telephone AS telephone_5, t0.siret AS siret_6, t0.is_active AS is_active_7, t0.eloa_ref AS eloa_ref_8, t0.eloa_last_check AS eloa_last_check_9, t0.eloa_statut AS eloa_statut_10, t0.libelle AS libelle_11, t0.reference_entite AS reference_entite_12, t0.raison_sociale AS raison_sociale_13, t0.ref_type_reseau AS ref_type_reseau_14, t0.orias AS orias_15, t0.description AS description_16, t0.has_grey_card_service AS has_grey_card_service_17, t0.slug AS slug_18, t0.has_loyalty_program AS has_loyalty_program_19, t0.has_up_my_shop AS has_up_my_shop_20, t0.latitude AS latitude_21, t0.longitude AS longitude_22, t0.royalty_network_date AS royalty_network_date_23, t0.royalty_remainder AS royalty_remainder_24, t0.fiscal_code_it AS fiscal_code_it_25, t0.leocare_id AS leocare_id_26, t0.autoscout24_api_id AS autoscout24_api_id_27, t0.up_my_shop_url AS up_my_shop_url_28, t0.lacentrale_id AS lacentrale_id_29, t0.has_annoncesautomobile AS has_annoncesautomobile_30, t0.definitively_inactive AS definitively_inactive_31, t0.first_contract_date AS first_contract_date_32, t0.opening_date AS opening_date_33, t0.vosfactures_id AS vosfactures_id_34, t0.vosfactures_client_id AS vosfactures_client_id_35, t0.grey_card_website AS grey_card_website_36, t0.has_cps AS has_cps_37, t0.contract_date AS contract_date_38, t0.autoscout24_id AS autoscout24_id_39, t0.paruvendu_id AS paruvendu_id_40, t0.ouestfrance_id AS ouestfrance_id_41, t0.atoutcoin_id AS atoutcoin_id_42, t0.royalty_variable_date AS royalty_variable_date_43, t0.royalty_communication_date AS royalty_communication_date_44, t0.agency_migrated AS agency_migrated_45, t0.facturation_id AS facturation_id_46, t0.invoice_number AS invoice_number_47, t0.address_number AS address_number_48, t0.address_extension AS address_extension_49, t0.address_street AS address_street_50, t0.address AS address_51, t0.created_at AS created_at_52, t0.updated_at AS updated_at_53, t0.city_id AS city_id_54, t0.company_id AS company_id_55, t0.royalty_network_id AS royalty_network_id_56, t0.royalty_communication_id AS royalty_communication_id_57, t0.royalty_variable_id AS royalty_variable_id_58, t0.close_reason_id AS close_reason_id_59 FROM agency t0 WHERE t0.slug = 'namur-sud-floreffe' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.insee_code AS insee_code_6,
  t0.department_id AS department_id_7
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.insee_code AS insee_code_6, t0.department_id AS department_id_7 FROM city t0 WHERE t0.id = 36287;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3,
  t0.country_id AS country_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.country_id AS country_id_4 FROM department t0 WHERE t0.id = 109;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.tax AS tax_3,
  t0.reference_eloa AS reference_eloa_4,
  t0.label AS label_5
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tax_number AS tax_number_3,
  t0.rcs AS rcs_4,
  t0.capital AS capital_5,
  t0.iban AS iban_6,
  t0.bic AS bic_7,
  t0.telephone AS telephone_8,
  t0.siret AS siret_9,
  t0.address_number AS address_number_10,
  t0.address_extension AS address_extension_11,
  t0.address_street AS address_street_12,
  t0.address AS address_13,
  t0.company_type_id AS company_type_id_14,
  t0.city_id AS city_id_15
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_number AS tax_number_3, t0.rcs AS rcs_4, t0.capital AS capital_5, t0.iban AS iban_6, t0.bic AS bic_7, t0.telephone AS telephone_8, t0.siret AS siret_9, t0.address_number AS address_number_10, t0.address_extension AS address_extension_11, t0.address_street AS address_street_12, t0.address AS address_13, t0.company_type_id AS company_type_id_14, t0.city_id AS city_id_15 FROM company t0 WHERE t0.id = 1295;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  company_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM company_type t0 WHERE t0.id = 7;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_service IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_service IN (1) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_agency_presentation IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_agency_presentation IN (1) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_workmate IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_workmate IN (1) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_price_buyer IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_price_buyer IN (1) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_quality_product_buyer IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_quality_product_buyer IN (1) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_service IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_service IN (2) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_agency_presentation IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_agency_presentation IN (2) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_workmate IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_workmate IN (2) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_price_buyer IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_price_buyer IN (2) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_quality_product_buyer IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_quality_product_buyer IN (2) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_service IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_service IN (3) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_agency_presentation IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_agency_presentation IN (3) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_workmate IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_workmate IN (3) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_price_buyer IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_price_buyer IN (3) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_quality_product_buyer IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_quality_product_buyer IN (3) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  survey_satisfaction s0_
  INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id
  INNER JOIN agency a2_ ON v1_.agency_id = a2_.id
WHERE
  s0_.note_service IN (?)
  AND s0_.active IN (?)
  AND a2_.id IN (?)
LIMIT
  1

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_service IN (4) AND s0_.active IN (1) AND a2_.id IN (61) LIMIT 1;