Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.vch_code AS vch_code_2,
  t0.vch_name AS vch_name_3,
  t0.vch_owner_id AS vch_owner_id_4,
  t0.vch_areaPosition AS vch_areaPosition_5,
  t0.vch_position AS vch_position_6,
  t0.startup_count AS startup_count_7,
  t0.t_hall_i_id AS t_hall_i_id_8
FROM
  stand t0

SELECT t0.id AS id_1, t0.vch_code AS vch_code_2, t0.vch_name AS vch_name_3, t0.vch_owner_id AS vch_owner_id_4, t0.vch_areaPosition AS vch_areaPosition_5, t0.vch_position AS vch_position_6, t0.startup_count AS startup_count_7, t0.t_hall_i_id AS t_hall_i_id_8 FROM stand t0;

SELECT
  t0.id AS id_1,
  t0.vch_libelle AS vch_libelle_2,
  t0.vch_libelle_en AS vch_libelle_en_3,
  t0.identifiant AS identifiant_4,
  t0.type AS type_5,
  t0.color AS color_6,
  t0.filter_name AS filter_name_7,
  t0.filter_name_en AS filter_name_en_8,
  t0.vch_active AS vch_active_9,
  t0.ordre AS ordre_10,
  t0.idkey AS idkey_11,
  t0.same_subject AS same_subject_12,
  t0.hidden AS hidden_13,
  t0.parent_id AS parent_id_14
FROM
  app_filter t0
  INNER JOIN exposant_app_filter ON t0.id = exposant_app_filter.filter_id
WHERE
  exposant_app_filter.exposant_id = ?

SELECT t0.id AS id_1, t0.vch_libelle AS vch_libelle_2, t0.vch_libelle_en AS vch_libelle_en_3, t0.identifiant AS identifiant_4, t0.type AS type_5, t0.color AS color_6, t0.filter_name AS filter_name_7, t0.filter_name_en AS filter_name_en_8, t0.vch_active AS vch_active_9, t0.ordre AS ordre_10, t0.idkey AS idkey_11, t0.same_subject AS same_subject_12, t0.hidden AS hidden_13, t0.parent_id AS parent_id_14 FROM app_filter t0 INNER JOIN exposant_app_filter ON t0.id = exposant_app_filter.filter_id WHERE exposant_app_filter.exposant_id = 1946;

SELECT
  t0.id AS id_1,
  t0.vch_code AS vch_code_2,
  t0.vch_name AS vch_name_3,
  t0.vch_owner_id AS vch_owner_id_4,
  t0.vch_areaPosition AS vch_areaPosition_5,
  t0.vch_position AS vch_position_6,
  t0.startup_count AS startup_count_7,
  t0.t_hall_i_id AS t_hall_i_id_8
FROM
  stand t0
  INNER JOIN exposant_stand ON t0.id = exposant_stand.stand_id
WHERE
  exposant_stand.exposant_id = ?

SELECT t0.id AS id_1, t0.vch_code AS vch_code_2, t0.vch_name AS vch_name_3, t0.vch_owner_id AS vch_owner_id_4, t0.vch_areaPosition AS vch_areaPosition_5, t0.vch_position AS vch_position_6, t0.startup_count AS startup_count_7, t0.t_hall_i_id AS t_hall_i_id_8 FROM stand t0 INNER JOIN exposant_stand ON t0.id = exposant_stand.stand_id WHERE exposant_stand.exposant_id = 1946;

SELECT
  t0.id AS id_1,
  t0.vch_code AS vch_code_2,
  t0.vch_name AS vch_name_3,
  t0.vch_plan AS vch_plan_4,
  t0.t_map_id AS t_map_id_5
FROM
  thall t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.vch_code AS vch_code_2, t0.vch_name AS vch_name_3, t0.vch_plan AS vch_plan_4, t0.t_map_id AS t_map_id_5 FROM thall t0 WHERE t0.id = 20;

SELECT
  e0_.id AS id_0,
  e0_.vch_code AS vch_code_1,
  e0_.idExt AS idExt_2,
  e0_.vch_name AS vch_name_3,
  e0_.vch_new AS vch_new_4,
  e0_.vch_novelty AS vch_novelty_5,
  e0_.vch_desc AS vch_desc_6,
  e0_.vch_desc_EN AS vch_desc_EN_7,
  e0_.vch_countryName AS vch_countryName_8,
  e0_.vch_twitter AS vch_twitter_9,
  e0_.dt_start AS dt_start_10,
  e0_.dt_end AS dt_end_11,
  e0_.dt_modif AS dt_modif_12,
  e0_.b_active AS b_active_13,
  e0_.hidden AS hidden_14,
  e0_.vch_zone AS vch_zone_15,
  e0_.vch_startup AS vch_startup_16,
  e0_.vch_adresse AS vch_adresse_17,
  e0_.vch_cp AS vch_cp_18,
  e0_.vch_ville AS vch_ville_19,
  e0_.vch_email AS vch_email_20,
  e0_.vch_adresse2 AS vch_adresse2_21,
  e0_.vch_tel AS vch_tel_22,
  e0_.vch_fax AS vch_fax_23,
  e0_.vch_web AS vch_web_24,
  e0_.vch_nomcontact AS vch_nomcontact_25,
  e0_.vch_prenomcontact AS vch_prenomcontact_26,
  e0_.vch_telcontact AS vch_telcontact_27,
  e0_.vch_faxcontact AS vch_faxcontact_28,
  e0_.vch_emailcontact AS vch_emailcontact_29,
  e0_.vch_functioncontact AS vch_functioncontact_30,
  e0_.vch_facebook AS vch_facebook_31,
  e0_.vch_linkedin AS vch_linkedin_32,
  e0_.logo AS logo_33,
  e0_.hostedById AS hostedById_34,
  e0_.startupStand AS startupStand_35,
  e0_.presence AS presence_36,
  e0_.qrCode AS qrCode_37,
  e0_.logoUrl AS logoUrl_38,
  e0_.vch_stand AS vch_stand_39,
  e0_.identifiant AS identifiant_40,
  e0_.vch_option_gold AS vch_option_gold_41,
  e0_.vch_option_feature AS vch_option_feature_42,
  e0_.vch_reason_sociale AS vch_reason_sociale_43,
  e0_.vch_short_description AS vch_short_description_44,
  e0_.vch_short_description_en AS vch_short_description_en_45,
  e0_.sponsor AS sponsor_46,
  e0_.sponsor_order AS sponsor_order_47,
  e0_.badge_rank AS badge_rank_48
FROM
  exposant e0_
WHERE
  e0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  e0_.vch_name ASC

SELECT e0_.id AS id_0, e0_.vch_code AS vch_code_1, e0_.idExt AS idExt_2, e0_.vch_name AS vch_name_3, e0_.vch_new AS vch_new_4, e0_.vch_novelty AS vch_novelty_5, e0_.vch_desc AS vch_desc_6, e0_.vch_desc_EN AS vch_desc_EN_7, e0_.vch_countryName AS vch_countryName_8, e0_.vch_twitter AS vch_twitter_9, e0_.dt_start AS dt_start_10, e0_.dt_end AS dt_end_11, e0_.dt_modif AS dt_modif_12, e0_.b_active AS b_active_13, e0_.hidden AS hidden_14, e0_.vch_zone AS vch_zone_15, e0_.vch_startup AS vch_startup_16, e0_.vch_adresse AS vch_adresse_17, e0_.vch_cp AS vch_cp_18, e0_.vch_ville AS vch_ville_19, e0_.vch_email AS vch_email_20, e0_.vch_adresse2 AS vch_adresse2_21, e0_.vch_tel AS vch_tel_22, e0_.vch_fax AS vch_fax_23, e0_.vch_web AS vch_web_24, e0_.vch_nomcontact AS vch_nomcontact_25, e0_.vch_prenomcontact AS vch_prenomcontact_26, e0_.vch_telcontact AS vch_telcontact_27, e0_.vch_faxcontact AS vch_faxcontact_28, e0_.vch_emailcontact AS vch_emailcontact_29, e0_.vch_functioncontact AS vch_functioncontact_30, e0_.vch_facebook AS vch_facebook_31, e0_.vch_linkedin AS vch_linkedin_32, e0_.logo AS logo_33, e0_.hostedById AS hostedById_34, e0_.startupStand AS startupStand_35, e0_.presence AS presence_36, e0_.qrCode AS qrCode_37, e0_.logoUrl AS logoUrl_38, e0_.vch_stand AS vch_stand_39, e0_.identifiant AS identifiant_40, e0_.vch_option_gold AS vch_option_gold_41, e0_.vch_option_feature AS vch_option_feature_42, e0_.vch_reason_sociale AS vch_reason_sociale_43, e0_.vch_short_description AS vch_short_description_44, e0_.vch_short_description_en AS vch_short_description_en_45, e0_.sponsor AS sponsor_46, e0_.sponsor_order AS sponsor_order_47, e0_.badge_rank AS badge_rank_48 FROM exposant e0_ WHERE e0_.id IN (1946, 643, 728, 245, 875, 48, 1588, 386, 2110, 2142, 2286, 676, 969, 93, 778, 1522, 535, 430, 752, 568, 552, 830, 613, 5, 1459, 289, 1697, 1465, 959, 1006, 1770, 874, 460, 2123, 623, 1163, 1052, 2125, 513, 1817, 455, 510, 597, 817, 1961, 256, 2291, 1752, 1372, 395, 832, 926, 490, 1972, 1435, 235, 1393, 265, 1471, 1529, 292, 2130, 1411, 608, 908, 464, 2050, 189, 1737, 849, 1327, 173, 2193, 1357, 2155, 388, 947, 1260, 2134, 384, 2194, 2239, 1362, 1952, 1950, 1056, 359, 1566, 581, 1276, 2279, 1918, 920, 237, 586, 2042, 1205, 2223, 2007, 152) ORDER BY e0_.vch_name ASC;

SELECT
  t0.id AS id_1,
  t0.level AS level_2,
  t0.label AS label_3,
  t0.name AS name_4,
  t0.access AS access_5,
  t0.actions_disabled AS actions_disabled_6,
  t0.menus_app_manager AS menus_app_manager_7,
  t0.is_admin AS is_admin_8,
  t0.is_app_manager AS is_app_manager_9,
  t0.is_patrimony_manager AS is_patrimony_manager_10,
  t0.date_created AS date_created_11
FROM
  role t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.level AS level_2, t0.label AS label_3, t0.name AS name_4, t0.access AS access_5, t0.actions_disabled AS actions_disabled_6, t0.menus_app_manager AS menus_app_manager_7, t0.is_admin AS is_admin_8, t0.is_app_manager AS is_app_manager_9, t0.is_patrimony_manager AS is_patrimony_manager_10, t0.date_created AS date_created_11 FROM role t0 WHERE t0.name = 'ROLE_ADMIN' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.vch_libelle AS vch_libelle_2,
  t0.vch_libelle_en AS vch_libelle_en_3,
  t0.identifiant AS identifiant_4,
  t0.type AS type_5,
  t0.color AS color_6,
  t0.filter_name AS filter_name_7,
  t0.filter_name_en AS filter_name_en_8,
  t0.vch_active AS vch_active_9,
  t0.ordre AS ordre_10,
  t0.idkey AS idkey_11,
  t0.same_subject AS same_subject_12,
  t0.hidden AS hidden_13,
  t0.parent_id AS parent_id_14
FROM
  app_filter t0
WHERE
  t0.filter_name = ?

SELECT t0.id AS id_1, t0.vch_libelle AS vch_libelle_2, t0.vch_libelle_en AS vch_libelle_en_3, t0.identifiant AS identifiant_4, t0.type AS type_5, t0.color AS color_6, t0.filter_name AS filter_name_7, t0.filter_name_en AS filter_name_en_8, t0.vch_active AS vch_active_9, t0.ordre AS ordre_10, t0.idkey AS idkey_11, t0.same_subject AS same_subject_12, t0.hidden AS hidden_13, t0.parent_id AS parent_id_14 FROM app_filter t0 WHERE t0.filter_name = 'Salon';

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.vch_name AS vch_name_1
FROM
  exposant e0_
ORDER BY
  e0_.vch_name ASC
LIMIT
  100

SELECT DISTINCT e0_.id AS id_0, e0_.vch_name AS vch_name_1 FROM exposant e0_ ORDER BY e0_.vch_name ASC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.password AS password_2,
  t0.token AS token_3,
  t0.username AS username_4,
  t0.username_canonical AS username_canonical_5,
  t0.roles AS roles_6,
  t0.email AS email_7,
  t0.email_canonical AS email_canonical_8,
  t0.salt AS salt_9,
  t0.confirmation_token AS confirmation_token_10,
  t0.password_requested_at AS password_requested_at_11,
  t0.last_login AS last_login_12,
  t0.enabled AS enabled_13
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.password AS password_2, t0.token AS token_3, t0.username AS username_4, t0.username_canonical AS username_canonical_5, t0.roles AS roles_6, t0.email AS email_7, t0.email_canonical AS email_canonical_8, t0.salt AS salt_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.last_login AS last_login_12, t0.enabled AS enabled_13 FROM app_user t0 WHERE t0.id = 14;

SELECT
  count(e0_.id) AS sclr_0
FROM
  exposant e0_

SELECT count(e0_.id) AS sclr_0 FROM exposant e0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.etat AS etat_3,
  t0.env AS env_4,
  t0.mode AS mode_5,
  t0.traductionSite AS traductionSite_6,
  t0.langue AS langue_7,
  t0.operateurApi AS operateurApi_8,
  t0.rgbd AS rgbd_9,
  t0.logoSalon AS logoSalon_10,
  t0.fond AS fond_11,
  t0.plansalon AS plansalon_12,
  t0.logoLegend AS logoLegend_13,
  t0.publicite AS publicite_14,
  t0.produitExposant AS produitExposant_15,
  t0.awardInnovation AS awardInnovation_16,
  t0.updated_at AS updated_at_17,
  t0.started_at AS started_at_18,
  t0.ended_at AS ended_at_19,
  t0.logo_exposant AS logo_exposant_20,
  t0.organisateur_id AS organisateur_id_21,
  t0.chart_id AS chart_id_22,
  t0.pac_expo_id AS pac_expo_id_23
FROM
  salon t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3, t0.env AS env_4, t0.mode AS mode_5, t0.traductionSite AS traductionSite_6, t0.langue AS langue_7, t0.operateurApi AS operateurApi_8, t0.rgbd AS rgbd_9, t0.logoSalon AS logoSalon_10, t0.fond AS fond_11, t0.plansalon AS plansalon_12, t0.logoLegend AS logoLegend_13, t0.publicite AS publicite_14, t0.produitExposant AS produitExposant_15, t0.awardInnovation AS awardInnovation_16, t0.updated_at AS updated_at_17, t0.started_at AS started_at_18, t0.ended_at AS ended_at_19, t0.logo_exposant AS logo_exposant_20, t0.organisateur_id AS organisateur_id_21, t0.chart_id AS chart_id_22, t0.pac_expo_id AS pac_expo_id_23 FROM salon t0;