Symfony Profiler

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  sync
SET
  message = ?
WHERE
  id = ?

UPDATE sync SET message = '<br><br>16/03/2026 11:34:52: <b>Prescript exécution TERMINE</b> <br>' WHERE id = 6;

SELECT
  t0.id AS id_1,
  t0.identifiant AS identifiant_2,
  t0.sync_exposant AS sync_exposant_3,
  t0.sync_conf AS sync_conf_4,
  t0.active AS active_5,
  t0.date AS date_6,
  t0.version AS version_7,
  t0.delta_img AS delta_img_8,
  t0.step AS step_9,
  t0.steplock AS steplock_10,
  t0.message AS message_11,
  t0.light AS light_12,
  t0.delta_sqlite_filename AS delta_sqlite_filename_13
FROM
  sync t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.sync_exposant AS sync_exposant_3, t0.sync_conf AS sync_conf_4, t0.active AS active_5, t0.date AS date_6, t0.version AS version_7, t0.delta_img AS delta_img_8, t0.step AS step_9, t0.steplock AS steplock_10, t0.message AS message_11, t0.light AS light_12, t0.delta_sqlite_filename AS delta_sqlite_filename_13 FROM sync t0 ORDER BY t0.id DESC LIMIT 1;

UPDATE
  sync
SET
  steplock = ?
WHERE
  id = ?

UPDATE sync SET steplock = 1 WHERE id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.target AS target_3,
  t0.target_type AS target_type_4,
  t0.source_id AS source_id_5,
  t0.target_id AS target_id_6,
  t0.image_folder AS image_folder_7,
  t0.general_mapping AS general_mapping_8,
  t0.pagination AS pagination_9,
  t0.ordre AS ordre_10,
  t0.active AS active_11,
  t12.id AS id_13,
  t12.mapping_id AS mapping_id_14,
  t0.data_provider_id AS data_provider_id_15,
  t0.mapping_collection_id AS mapping_collection_id_16
FROM
  mapping t0
  LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id
WHERE
  t0.general_mapping = ?
  AND t0.active = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.target AS target_3, t0.target_type AS target_type_4, t0.source_id AS source_id_5, t0.target_id AS target_id_6, t0.image_folder AS image_folder_7, t0.general_mapping AS general_mapping_8, t0.pagination AS pagination_9, t0.ordre AS ordre_10, t0.active AS active_11, t12.id AS id_13, t12.mapping_id AS mapping_id_14, t0.data_provider_id AS data_provider_id_15, t0.mapping_collection_id AS mapping_collection_id_16 FROM mapping t0 LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id WHERE t0.general_mapping = 1 AND t0.active = 'true' ORDER BY t0.ordre ASC;

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.split_chunk AS split_chunk_22,
  t0.provider_id AS provider_id_23
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.split_chunk AS split_chunk_22, t0.provider_id AS provider_id_23 FROM data_provider t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.script AS script_4,
  t0.php_script AS php_script_5,
  t0.script_log AS script_log_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.entity_name AS entity_name_9,
  t0.for_sync AS for_sync_10,
  t0.ordre AS ordre_11
FROM
  sql_script t0
WHERE
  t0.for_sync = ?
  AND t0.type = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.script AS script_4, t0.php_script AS php_script_5, t0.script_log AS script_log_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.entity_name AS entity_name_9, t0.for_sync AS for_sync_10, t0.ordre AS ordre_11 FROM sql_script t0 WHERE t0.for_sync = 1 AND t0.type = 'prescript' ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.script AS script_4,
  t0.php_script AS php_script_5,
  t0.script_log AS script_log_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.entity_name AS entity_name_9,
  t0.for_sync AS for_sync_10,
  t0.ordre AS ordre_11
FROM
  sql_script t0
WHERE
  t0.type = ?
  AND t0.entity_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.script AS script_4, t0.php_script AS php_script_5, t0.script_log AS script_log_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.entity_name AS entity_name_9, t0.for_sync AS for_sync_10, t0.ordre AS ordre_11 FROM sql_script t0 WHERE t0.type = 'vidange' AND t0.entity_name = 'texhibitors' LIMIT 1;

UPDATE
  sync
SET
  step = ?
WHERE
  id = ?

UPDATE sync SET step = 2 WHERE id = 6;

SET
  FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE `exposant`;

TRUNCATE TABLE `exposant_apport_perso`;

TRUNCATE TABLE `exposant_zonegeo`;

TRUNCATE TABLE `exposant_nomenclature`;

TRUNCATE TABLE `exposant_parcours`;

TRUNCATE TABLE `exposant_pays`;

TRUNCATE TABLE `exposant_produit`;

TRUNCATE TABLE `exposant_stand`;

TRUNCATE TABLE `exposant_tactivity_area`;

TRUNCATE TABLE `exposant_app_filter`;

#TRUNCATE TABLE `apport_personnel`;

TRUNCATE TABLE `nomenclature`;

#TRUNCATE TABLE `parcours`;

TRUNCATE TABLE `pays`;

TRUNCATE TABLE `produit`;

#TRUNCATE TABLE `tactivity_area`;

#TRUNCATE TABLE `thall`;

TRUNCATE TABLE `brand`;

SET
  FOREIGN_KEY_CHECKS = 1;

SET FOREIGN_KEY_CHECKS = 0; 
                            TRUNCATE TABLE `exposant`;
                            TRUNCATE TABLE `exposant_apport_perso`;
                            TRUNCATE TABLE `exposant_zonegeo`;
                            TRUNCATE TABLE `exposant_nomenclature`;
                            TRUNCATE TABLE `exposant_parcours`;
                            TRUNCATE TABLE `exposant_pays`;
                            TRUNCATE TABLE `exposant_produit`;
                            TRUNCATE TABLE `exposant_stand`;
                            TRUNCATE TABLE `exposant_tactivity_area`; 
                            TRUNCATE TABLE `exposant_app_filter`;                          
                            #TRUNCATE TABLE `apport_personnel`;

                            TRUNCATE TABLE `nomenclature`;
                            #TRUNCATE TABLE `parcours`;

                            TRUNCATE TABLE `pays`;
                            TRUNCATE TABLE `produit`;
                            #TRUNCATE TABLE `tactivity_area`;

                            #TRUNCATE TABLE `thall`;

                            TRUNCATE TABLE `brand`;                           
                            SET FOREIGN_KEY_CHECKS = 1;;