Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.centre_coordinate AS centre_coordinate_3
FROM
  maps_region t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.centre_coordinate AS centre_coordinate_3 FROM maps_region t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 11;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 14;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 15;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 16;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 17;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.region_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.region_id = 18;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.manager AS manager_3,
  t0.mail AS mail_4,
  t0.phone AS phone_5,
  t0.coordinate AS coordinate_6,
  t0.removed AS removed_7,
  t0.region_id AS region_id_8
FROM
  maps_agency t0
WHERE
  t0.removed = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.mail AS mail_4, t0.phone AS phone_5, t0.coordinate AS coordinate_6, t0.removed AS removed_7, t0.region_id AS region_id_8 FROM maps_agency t0 WHERE t0.removed = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.maps_color AS maps_color_3,
  t0.hover_color AS hover_color_4,
  t0.marker_color AS marker_color_5
FROM
  maps_configuration t0
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.maps_color AS maps_color_3, t0.hover_color AS hover_color_4, t0.marker_color AS marker_color_5 FROM maps_configuration t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.siret AS siret_4,
  t0.tva AS tva_5,
  t0.phone AS phone_6,
  t0.siren AS siren_7,
  t0.nic AS nic_8,
  t0.cat_juridique AS cat_juridique_9,
  t0.denomination AS denomination_10,
  t0.activite_principal AS activite_principal_11,
  t0.address1 AS address1_12,
  t0.address2 AS address2_13,
  t0.zip_code AS zip_code_14,
  t0.city AS city_15,
  t0.frequency AS frequency_16,
  t0.iban AS iban_17,
  t0.bic AS bic_18,
  t0.mandate_id AS mandate_id_19,
  t0.mandate_date AS mandate_date_20,
  t0.offer_value AS offer_value_21,
  t0.societe_old_id AS societe_old_id_22,
  t0.tirelire AS tirelire_23,
  t0.abondement AS abondement_24,
  t0.subdomain AS subdomain_25,
  t0.color_primary AS color_primary_26,
  t0.color_secondary AS color_secondary_27,
  t0.contract_date AS contract_date_28,
  t0.date_abondement AS date_abondement_29,
  t0.bans AS bans_30,
  t0.bans_sg AS bans_sg_31,
  t0.card_price AS card_price_32,
  t0.wallet_id AS wallet_id_33,
  t0.start_contract AS start_contract_34,
  t0.contract_duration AS contract_duration_35,
  t0.renewal_year AS renewal_year_36,
  t0.months_notice AS months_notice_37,
  t0.date_cancellation AS date_cancellation_38,
  t0.theoretical_end_contract AS theoretical_end_contract_39,
  t0.end_contract_renewal AS end_contract_renewal_40,
  t0.date_request_cancellation AS date_request_cancellation_41,
  t0.benefeciary_id AS benefeciary_id_42,
  t0.offer_id AS offer_id_43,
  t0.salesperson_id AS salesperson_id_44,
  t0.departement_id AS departement_id_45,
  t46.id AS id_47,
  t46.bic AS bic_48,
  t46.iban AS iban_49,
  t46.company_id_id AS company_id_id_50,
  t0.debit_bank_id AS debit_bank_id_51
FROM
  company t0
  LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id
WHERE
  t0.subdomain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.siret AS siret_4, t0.tva AS tva_5, t0.phone AS phone_6, t0.siren AS siren_7, t0.nic AS nic_8, t0.cat_juridique AS cat_juridique_9, t0.denomination AS denomination_10, t0.activite_principal AS activite_principal_11, t0.address1 AS address1_12, t0.address2 AS address2_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.frequency AS frequency_16, t0.iban AS iban_17, t0.bic AS bic_18, t0.mandate_id AS mandate_id_19, t0.mandate_date AS mandate_date_20, t0.offer_value AS offer_value_21, t0.societe_old_id AS societe_old_id_22, t0.tirelire AS tirelire_23, t0.abondement AS abondement_24, t0.subdomain AS subdomain_25, t0.color_primary AS color_primary_26, t0.color_secondary AS color_secondary_27, t0.contract_date AS contract_date_28, t0.date_abondement AS date_abondement_29, t0.bans AS bans_30, t0.bans_sg AS bans_sg_31, t0.card_price AS card_price_32, t0.wallet_id AS wallet_id_33, t0.start_contract AS start_contract_34, t0.contract_duration AS contract_duration_35, t0.renewal_year AS renewal_year_36, t0.months_notice AS months_notice_37, t0.date_cancellation AS date_cancellation_38, t0.theoretical_end_contract AS theoretical_end_contract_39, t0.end_contract_renewal AS end_contract_renewal_40, t0.date_request_cancellation AS date_request_cancellation_41, t0.benefeciary_id AS benefeciary_id_42, t0.offer_id AS offer_id_43, t0.salesperson_id AS salesperson_id_44, t0.departement_id AS departement_id_45, t46.id AS id_47, t46.bic AS bic_48, t46.iban AS iban_49, t46.company_id_id AS company_id_id_50, t0.debit_bank_id AS debit_bank_id_51 FROM company t0 LEFT JOIN company_treezor_wallet t46 ON t46.company_id_id = t0.id WHERE t0.subdomain = 'developpement' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.platform AS platform_3,
  t0.parameters AS parameters_4
FROM
  customization t0
WHERE
  t0.label = ?
  AND t0.platform = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.platform AS platform_3, t0.parameters AS parameters_4 FROM customization t0 WHERE t0.label = 'banner' AND t0.platform = 'Web' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.description_home AS description_home_4,
  t0.link_video AS link_video_5,
  t0.image AS image_6,
  t0.image_group AS image_group_7,
  t0.position AS position_8,
  t0.reverse AS reverse_9,
  t0.slug AS slug_10,
  t0.display_home AS display_home_11
FROM
  solution t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_home AS description_home_4, t0.link_video AS link_video_5, t0.image AS image_6, t0.image_group AS image_group_7, t0.position AS position_8, t0.reverse AS reverse_9, t0.slug AS slug_10, t0.display_home AS display_home_11 FROM solution t0;

SELECT
  t0.id AS id_1,
  t0.icon AS icon_2,
  t0.url AS url_3,
  t0.active AS active_4,
  t0.position AS position_5
FROM
  social_media t0
WHERE
  t0.active = ?
ORDER BY
  t0.position ASC