Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.locale AS locale_7,
  t0.favorite_apps AS favorite_apps_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  activity t0

SELECT t0.id AS id_1, t0.title AS title_2 FROM activity t0;

SELECT
  DISTINCT r0_.country AS country_0
FROM
  retailer r0_

SELECT DISTINCT r0_.country AS country_0 FROM retailer r0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  `group` t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM `group` t0;

SELECT
  DISTINCT SUBSTRING(
    a0_.zipcode
    FROM
      1 FOR 2
  ) AS sclr_0
FROM
  address a0_
WHERE
  a0_.zipcode IS NOT NULL
  AND a0_.zipcode <> ?
  AND CHAR_LENGTH(a0_.zipcode) >= 2
ORDER BY
  sclr_0 ASC

SELECT DISTINCT SUBSTRING(a0_.zipcode FROM 1 FOR 2) AS sclr_0 FROM address a0_ WHERE a0_.zipcode IS NOT NULL AND a0_.zipcode <> '' AND CHAR_LENGTH(a0_.zipcode) >= 2 ORDER BY sclr_0 ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.created_at AS created_at_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.commercial_zone AS commercial_zone_13,
  t0.country AS country_14,
  t0.verify_by_bd AS verify_by_bd_15,
  t0.verify_by_na AS verify_by_na_16,
  t0.verify_by_rl AS verify_by_rl_17,
  t0.admin_comment AS admin_comment_18,
  t0.close AS close_19,
  t0.type_profile AS type_profile_20,
  t0.reseau AS reseau_21,
  t0.groupe AS groupe_22,
  t0.imported AS imported_23,
  t0.sap_code AS sap_code_24,
  t0.activity_id AS activity_id_25,
  t0.rachat_matiere_id AS rachat_matiere_id_26,
  t0.network_id AS network_id_27,
  t0.retailer_group_id AS retailer_group_id_28
FROM
  retailer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.id = '6631';

SELECT
  t0.id AS id_1,
  t0.action AS action_2,
  t0.logged_at AS logged_at_3,
  t0.object_id AS object_id_4,
  t0.object_class AS object_class_5,
  t0.version AS version_6,
  t0.data AS data_7,
  t0.username AS username_8
FROM
  ext_log_entries t0
WHERE
  t0.object_id = ?
  AND t0.object_class = ?
ORDER BY
  t0.logged_at DESC

SELECT t0.id AS id_1, t0.action AS action_2, t0.logged_at AS logged_at_3, t0.object_id AS object_id_4, t0.object_class AS object_class_5, t0.version AS version_6, t0.data AS data_7, t0.username AS username_8 FROM ext_log_entries t0 WHERE t0.object_id = 6631 AND t0.object_class = 'App\\Entity\\Retailer' ORDER BY t0.logged_at DESC;

SELECT
  t0.id AS id_1,
  t0.lastname AS lastname_2,
  t0.firstname AS firstname_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.service AS service_6,
  t0.job AS job_7,
  t0.created_at AS created_at_8,
  t0.mobile AS mobile_9,
  t0.confirm_delivery AS confirm_delivery_10,
  t0.confirm_loading AS confirm_loading_11,
  t0.to_be_check_bd AS to_be_check_bd_12,
  t0.to_be_check_na AS to_be_check_na_13,
  t0.to_be_check_rl AS to_be_check_rl_14,
  t0.comment AS comment_15,
  t0.is_verified AS is_verified_16,
  t0.imported AS imported_17,
  t0.to_be_check_ij AS to_be_check_ij_18,
  t0.to_be_check_ak AS to_be_check_ak_19,
  t0.send_invoice AS send_invoice_20,
  t0.good_weighing_contact AS good_weighing_contact_21,
  t0.entry_tracking_sheet_contact AS entry_tracking_sheet_contact_22,
  t0.box_rotation_contact AS box_rotation_contact_23,
  t0.sap_code AS sap_code_24,
  t0.send_price_offer AS send_price_offer_25,
  t0.receipt_order_contact AS receipt_order_contact_26,
  t0.to_be_check_cr AS to_be_check_cr_27,
  t0.retailer_id AS retailer_id_28,
  t0.service_list_id AS service_list_id_29,
  t0.gender_id AS gender_id_30
FROM
  contact t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.email AS email_4, t0.phone AS phone_5, t0.service AS service_6, t0.job AS job_7, t0.created_at AS created_at_8, t0.mobile AS mobile_9, t0.confirm_delivery AS confirm_delivery_10, t0.confirm_loading AS confirm_loading_11, t0.to_be_check_bd AS to_be_check_bd_12, t0.to_be_check_na AS to_be_check_na_13, t0.to_be_check_rl AS to_be_check_rl_14, t0.comment AS comment_15, t0.is_verified AS is_verified_16, t0.imported AS imported_17, t0.to_be_check_ij AS to_be_check_ij_18, t0.to_be_check_ak AS to_be_check_ak_19, t0.send_invoice AS send_invoice_20, t0.good_weighing_contact AS good_weighing_contact_21, t0.entry_tracking_sheet_contact AS entry_tracking_sheet_contact_22, t0.box_rotation_contact AS box_rotation_contact_23, t0.sap_code AS sap_code_24, t0.send_price_offer AS send_price_offer_25, t0.receipt_order_contact AS receipt_order_contact_26, t0.to_be_check_cr AS to_be_check_cr_27, t0.retailer_id AS retailer_id_28, t0.service_list_id AS service_list_id_29, t0.gender_id AS gender_id_30 FROM contact t0 WHERE t0.retailer_id = 6631;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  profiling t0
  INNER JOIN retailer_profiling ON t0.id = retailer_profiling.profiling_id
WHERE
  retailer_profiling.retailer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM profiling t0 INNER JOIN retailer_profiling ON t0.id = retailer_profiling.profiling_id WHERE retailer_profiling.retailer_id = 6631;

SELECT
  t0.id AS id_1,
  t0.siret AS siret_2,
  t0.denomination_unite_legale AS denomination_unite_legale_3,
  t0.complement_adresse_etablissement AS complement_adresse_etablissement_4,
  t0.code_postal_etablissement AS code_postal_etablissement_5,
  t0.libelle_commune_etablissement AS libelle_commune_etablissement_6,
  t0.created_at AS created_at_7,
  t0.retailer_id AS retailer_id_8
FROM
  siret_result t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.siret AS siret_2, t0.denomination_unite_legale AS denomination_unite_legale_3, t0.complement_adresse_etablissement AS complement_adresse_etablissement_4, t0.code_postal_etablissement AS code_postal_etablissement_5, t0.libelle_commune_etablissement AS libelle_commune_etablissement_6, t0.created_at AS created_at_7, t0.retailer_id AS retailer_id_8 FROM siret_result t0 WHERE t0.retailer_id = 6631;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.street2 AS street2_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.phone AS phone_7,
  t0.mobile AS mobile_8,
  t0.type AS type_9,
  t0.opening_hours AS opening_hours_10,
  t0.bp AS bp_11,
  t0.imported AS imported_12,
  t0.title AS title_13,
  t0.comment AS comment_14,
  t0.retailer_id AS retailer_id_15
FROM
  address t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.street2 AS street2_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mobile AS mobile_8, t0.type AS type_9, t0.opening_hours AS opening_hours_10, t0.bp AS bp_11, t0.imported AS imported_12, t0.title AS title_13, t0.comment AS comment_14, t0.retailer_id AS retailer_id_15 FROM address t0 WHERE t0.retailer_id = 6631;

SELECT
  t0.id AS id_1,
  t0.retailer_id AS retailer_id_2,
  t0.box_id AS box_id_3,
  t0.transportation_type_id AS transportation_type_id_4
FROM
  retailer_box_spec t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.retailer_id AS retailer_id_2, t0.box_id AS box_id_3, t0.transportation_type_id AS transportation_type_id_4 FROM retailer_box_spec t0 WHERE t0.retailer_id = 6631;

SELECT
  t0.id AS id_1,
  t0.qty AS qty_2,
  t0.created_at AS created_at_3,
  t0.delivered AS delivered_4,
  t0.removed AS removed_5,
  t0.filed_on AS filed_on_6,
  t0.back_on AS back_on_7,
  t0.comment AS comment_8,
  t0.retailer_id AS retailer_id_9,
  t0.box_id AS box_id_10
FROM
  box_qty t0
WHERE
  t0.retailer_id = ?
ORDER BY
  t0.box_id ASC,
  t0.filed_on ASC

SELECT t0.id AS id_1, t0.qty AS qty_2, t0.created_at AS created_at_3, t0.delivered AS delivered_4, t0.removed AS removed_5, t0.filed_on AS filed_on_6, t0.back_on AS back_on_7, t0.comment AS comment_8, t0.retailer_id AS retailer_id_9, t0.box_id AS box_id_10 FROM box_qty t0 WHERE t0.retailer_id = 6631 ORDER BY t0.box_id ASC, t0.filed_on ASC;

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.bank_account_number AS bank_account_number_3,
  t0.sap_code AS sap_code_4,
  t0.bank_id AS bank_id_5,
  t0.retailer_id AS retailer_id_6
FROM
  iban t0
WHERE
  t0.retailer_id = ?

SELECT t0.id AS id_1, t0.country AS country_2, t0.bank_account_number AS bank_account_number_3, t0.sap_code AS sap_code_4, t0.bank_id AS bank_id_5, t0.retailer_id AS retailer_id_6 FROM iban t0 WHERE t0.retailer_id = 6631;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  gender t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM gender t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  service t0
  INNER JOIN contact_service ON t0.id = contact_service.service_id
WHERE
  contact_service.contact_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM service t0 INNER JOIN contact_service ON t0.id = contact_service.service_id WHERE contact_service.contact_id = 7246;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  service t0
  INNER JOIN contact_service ON t0.id = contact_service.service_id
WHERE
  contact_service.contact_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM service t0 INNER JOIN contact_service ON t0.id = contact_service.service_id WHERE contact_service.contact_id = 7509;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1
FROM
  activity a0_
WHERE
  a0_.id IN (?)

SELECT a0_.id AS id_0, a0_.title AS title_1 FROM activity a0_ WHERE a0_.id IN ('3');

SELECT
  g0_.id AS id_0,
  g0_.title AS title_1
FROM
  gender g0_
WHERE
  g0_.id IN (?)

SELECT g0_.id AS id_0, g0_.title AS title_1 FROM gender g0_ WHERE g0_.id IN ('3');

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1
FROM
  service s0_
WHERE
  s0_.id IN (?)

SELECT s0_.id AS id_0, s0_.name AS name_1 FROM service s0_ WHERE s0_.id IN ('3');

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1
FROM
  service s0_
WHERE
  s0_.id IN (?)

SELECT s0_.id AS id_0, s0_.name AS name_1 FROM service s0_ WHERE s0_.id IN ('3');

SELECT
  g0_.id AS id_0,
  g0_.title AS title_1
FROM
  gender g0_
WHERE
  g0_.id IN (?)

SELECT g0_.id AS id_0, g0_.title AS title_1 FROM gender g0_ WHERE g0_.id IN ('3');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zipcode AS zipcode_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.siret AS siret_8,
  t0.tva_number AS tva_number_9,
  t0.created_at AS created_at_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.commercial_zone AS commercial_zone_13,
  t0.country AS country_14,
  t0.verify_by_bd AS verify_by_bd_15,
  t0.verify_by_na AS verify_by_na_16,
  t0.verify_by_rl AS verify_by_rl_17,
  t0.admin_comment AS admin_comment_18,
  t0.close AS close_19,
  t0.type_profile AS type_profile_20,
  t0.reseau AS reseau_21,
  t0.groupe AS groupe_22,
  t0.imported AS imported_23,
  t0.sap_code AS sap_code_24,
  t0.activity_id AS activity_id_25,
  t0.rachat_matiere_id AS rachat_matiere_id_26,
  t0.network_id AS network_id_27,
  t0.retailer_group_id AS retailer_group_id_28
FROM
  retailer t0
WHERE
  t0.siret = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.siret AS siret_8, t0.tva_number AS tva_number_9, t0.created_at AS created_at_10, t0.type AS type_11, t0.status AS status_12, t0.commercial_zone AS commercial_zone_13, t0.country AS country_14, t0.verify_by_bd AS verify_by_bd_15, t0.verify_by_na AS verify_by_na_16, t0.verify_by_rl AS verify_by_rl_17, t0.admin_comment AS admin_comment_18, t0.close AS close_19, t0.type_profile AS type_profile_20, t0.reseau AS reseau_21, t0.groupe AS groupe_22, t0.imported AS imported_23, t0.sap_code AS sap_code_24, t0.activity_id AS activity_id_25, t0.rachat_matiere_id AS rachat_matiere_id_26, t0.network_id AS network_id_27, t0.retailer_group_id AS retailer_group_id_28 FROM retailer t0 WHERE t0.siret = '490 887 700 00014' LIMIT 1;