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.remove_old_join_enabled AS remove_old_join_enabled_12,
  t3.function AS function_13,
  t3.sub_mapping_id AS sub_mapping_id_14
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.remove_old_join_enabled AS remove_old_join_enabled_12, t3.function AS function_13, t3.sub_mapping_id AS sub_mapping_id_14 FROM sub_mapping t0 LEFT JOIN field t3 ON t3.sub_mapping_id = t0.id WHERE t0.mapping_id = 24;

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 = 9;

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,
  t0.token_field AS token_field_8,
  t0.headers AS headers_9
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, t0.token_field AS token_field_8, t0.headers AS headers_9 FROM provider t0 WHERE t0.id = 5;

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.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 = 1;

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.general_mapping AS general_mapping_1
FROM
  mapping m0_
  INNER JOIN mapping_collection m1_ ON (
    m0_.mapping_collection_id = m1_.id
  )
WHERE
  m1_.enabled = ?
ORDER BY
  m0_.general_mapping DESC
LIMIT
  200

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

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_.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 (15, 18, 34, 51, 2, 20, 5, 24, 41, 29, 13, 30, 31, 32, 48, 16, 33, 49, 19, 52, 3, 21, 37, 53, 22, 38, 54, 6, 23, 39, 55, 7, 40, 17, 8, 25, 9, 26, 42, 10, 27, 43, 11, 28, 44, 12, 45, 46, 14, 47, 50, 35, 36) ORDER BY m0_.general_mapping DESC;

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,
  t0.ip AS ip_14
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, t0.ip AS ip_14 FROM app_user t0 WHERE t0.id = 15;

"COMMIT"

"COMMIT";

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.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.logo_produit AS logo_produit_21,
  t0.organisateur_id AS organisateur_id_22,
  t0.chart_id AS chart_id_23,
  t0.pac_expo_id AS pac_expo_id_24
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.logo_produit AS logo_produit_21, t0.organisateur_id AS organisateur_id_22, t0.chart_id AS chart_id_23, t0.pac_expo_id AS pac_expo_id_24 FROM salon t0;

INSERT INTO user_log (
  user, path, method, query, ip, created_at,
  user_agent
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_log (user, path, method, query, ip, created_at, user_agent) VALUES ('superadmin', '/easyadmin/mapping', 'GET', '[]', '10.75.11.100', '2026-06-18 09:42:21', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:152.0) Gecko/20100101 Firefox/152.0');

"START TRANSACTION"

"START TRANSACTION";