Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.mapping_id AS mapping_id_2,
  t3.id AS id_4,
  t3.source AS source_5,
  t3.source_type AS source_type_6,
  t3.target AS target_7,
  t3.target_type AS target_type_8,
  t3.relation AS relation_9,
  t3.target_value AS target_value_10,
  t3.export AS export_11,
  t3.function AS function_12,
  t3.sub_mapping_id AS sub_mapping_id_13
FROM
  sub_mapping t0
  LEFT JOIN field t3 ON t3.sub_mapping_id = t0.id
WHERE
  t0.mapping_id = ?

SELECT t0.id AS id_1, t0.mapping_id AS mapping_id_2, t3.id AS id_4, t3.source AS source_5, t3.source_type AS source_type_6, t3.target AS target_7, t3.target_type AS target_type_8, t3.relation AS relation_9, t3.target_value AS target_value_10, t3.export AS export_11, t3.function AS function_12, t3.sub_mapping_id AS sub_mapping_id_13 FROM sub_mapping t0 LEFT JOIN field t3 ON t3.sub_mapping_id = t0.id WHERE t0.mapping_id = 49;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.source_data_type AS source_data_type_3,
  t0.source_data_url AS source_data_url_4,
  t0.source_data_filter AS source_data_filter_5,
  t0.disable_filter AS disable_filter_6,
  t0.cloned_data_url AS cloned_data_url_7,
  t0.pagination AS pagination_8,
  t0.disable AS disable_9,
  t0.number_per_page AS number_per_page_10,
  t0.source_data_xls AS source_data_xls_11,
  t0.property_index AS property_index_12,
  t0.method AS method_13,
  t0.max_iterations AS max_iterations_14,
  t0.iterator_per_page_selector AS iterator_per_page_selector_15,
  t0.iterator_page_selector AS iterator_page_selector_16,
  t0.iterator_initial_page AS iterator_initial_page_17,
  t0.http_header AS http_header_18,
  t0.enable_cast_to_array AS enable_cast_to_array_19,
  t0.sub_fields_to_cast AS sub_fields_to_cast_20,
  t0.take_mode AS take_mode_21,
  t0.provider_id AS provider_id_22
FROM
  data_provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.source_data_type AS source_data_type_3, t0.source_data_url AS source_data_url_4, t0.source_data_filter AS source_data_filter_5, t0.disable_filter AS disable_filter_6, t0.cloned_data_url AS cloned_data_url_7, t0.pagination AS pagination_8, t0.disable AS disable_9, t0.number_per_page AS number_per_page_10, t0.source_data_xls AS source_data_xls_11, t0.property_index AS property_index_12, t0.method AS method_13, t0.max_iterations AS max_iterations_14, t0.iterator_per_page_selector AS iterator_per_page_selector_15, t0.iterator_page_selector AS iterator_page_selector_16, t0.iterator_initial_page AS iterator_initial_page_17, t0.http_header AS http_header_18, t0.enable_cast_to_array AS enable_cast_to_array_19, t0.sub_fields_to_cast AS sub_fields_to_cast_20, t0.take_mode AS take_mode_21, t0.provider_id AS provider_id_22 FROM data_provider t0 WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.authorisation AS authorisation_3,
  t0.auth_method AS auth_method_4,
  t0.auth_post_fields AS auth_post_fields_5,
  t0.auth_url AS auth_url_6,
  t0.active AS active_7
FROM
  provider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.authorisation AS authorisation_3, t0.auth_method AS auth_method_4, t0.auth_post_fields AS auth_post_fields_5, t0.auth_url AS auth_url_6, t0.active AS active_7 FROM provider t0 WHERE t0.id = 1;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.target AS target_2,
  m0_.target_type AS target_type_3,
  m0_.source_id AS source_id_4,
  m0_.target_id AS target_id_5,
  m0_.image_folder AS image_folder_6,
  m0_.general_mapping AS general_mapping_7,
  m0_.pagination AS pagination_8,
  m0_.ordre AS ordre_9,
  m0_.active AS active_10,
  m0_.data_provider_id AS data_provider_id_11,
  m0_.mapping_collection_id AS mapping_collection_id_12
FROM
  mapping m0_
  INNER JOIN mapping_collection m1_ ON (
    m0_.mapping_collection_id = m1_.id
  )
WHERE
  m1_.enabled = ?
  AND m0_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
ORDER BY
  m0_.active DESC,
  m0_.general_mapping DESC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.target AS target_2, m0_.target_type AS target_type_3, m0_.source_id AS source_id_4, m0_.target_id AS target_id_5, m0_.image_folder AS image_folder_6, m0_.general_mapping AS general_mapping_7, m0_.pagination AS pagination_8, m0_.ordre AS ordre_9, m0_.active AS active_10, m0_.data_provider_id AS data_provider_id_11, m0_.mapping_collection_id AS mapping_collection_id_12 FROM mapping m0_ INNER JOIN mapping_collection m1_ ON (m0_.mapping_collection_id = m1_.id) WHERE m1_.enabled = 1 AND m0_.id IN (49, 26, 152, 156, 158, 168, 134, 150, 171, 50, 84, 135, 172, 68, 85, 136, 173, 27, 120, 137, 153, 174, 104, 138, 154, 175, 88, 122, 139, 155, 176, 55, 123, 140, 177, 57, 141, 157, 178, 91, 142, 179, 126, 143, 159, 180, 43, 127, 144, 165, 181, 44, 78, 94, 130, 114, 131, 47, 81, 148, 169, 133, 170, 83, 99, 117, 100, 118, 151, 101, 119, 86, 102, 53, 87, 105, 89, 106, 90, 107, 124, 108, 125, 92, 110, 93, 111, 112, 128, 145, 166, 79, 95, 113, 146, 167, 46, 96, 147, 97, 115, 132, 48, 82, 98, 116, 149, 121, 80, 66, 67, 51, 52, 69, 28, 70, 29, 54, 71, 30, 72, 31, 74, 37, 58, 75, 42, 59, 76, 60, 77, 61, 45, 62, 63, 64, 65) ORDER BY m0_.active DESC, m0_.general_mapping DESC;

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.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
  DISTINCT m0_.id AS id_0,
  m0_.active AS active_1,
  m0_.general_mapping AS general_mapping_2
FROM
  mapping m0_
  INNER JOIN mapping_collection m1_ ON (
    m0_.mapping_collection_id = m1_.id
  )
WHERE
  m1_.enabled = ?
ORDER BY
  m0_.active DESC,
  m0_.general_mapping DESC
LIMIT
  200

SELECT DISTINCT m0_.id AS id_0, m0_.active AS active_1, m0_.general_mapping AS general_mapping_2 FROM mapping m0_ INNER JOIN mapping_collection m1_ ON (m0_.mapping_collection_id = m1_.id) WHERE m1_.enabled = 1 ORDER BY m0_.active DESC, m0_.general_mapping DESC LIMIT 200;

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;

SELECT
  count(DISTINCT m0_.id) AS sclr_0
FROM
  mapping m0_
  INNER JOIN mapping_collection m1_ ON (
    m0_.mapping_collection_id = m1_.id
  )
WHERE
  m1_.enabled = ?

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM mapping m0_ INNER JOIN mapping_collection m1_ ON (m0_.mapping_collection_id = m1_.id) WHERE m1_.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.enabled AS enabled_3
FROM
  mapping_collection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM mapping_collection t0 WHERE t0.id = 3;