Symfony Profiler

Query Metrics

82 Database Queries

13 Different statements

535.57 ms Query time

1 Invalid entities

150 Managed entities

Queries

Group similar statements

default connection


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.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.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
"START TRANSACTION"
INSERT INTO user_log (user, path, method, query, ip, created_at, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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 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 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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 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 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.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.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.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.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.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.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.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 = ?
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 = ?
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.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.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 = ?
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.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 = ?
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.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

#▲	Time	Info
1	7.10 ms	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 = ? Parameters: [`15`] View formatted query View runnable query Explain query 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;
2	6.28 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
3	6.55 ms	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 Parameters: [`"ROLE_ADMIN"`] View formatted query View runnable query Explain query 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;
4	5.94 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
5	6.17 ms	INSERT INTO user_log (user, path, method, query, ip, created_at, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"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"`] View formatted query View runnable query Explain query 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');
6	6.67 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
7	8.19 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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;
8	7.49 ms	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 Parameters: [`1 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`] View formatted query View runnable query Explain query 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;
9	7.80 ms	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 = ? Parameters: [`24`] View formatted query View runnable query Explain query 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;
10	6.34 ms	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 = ? Parameters: [`41`] View formatted query View runnable query Explain query 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 = 41;
11	6.12 ms	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 = ? Parameters: [`29`] View formatted query View runnable query Explain query 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 = 29;
12	6.75 ms	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 = ? Parameters: [`13`] View formatted query View runnable query Explain query 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 = 13;
13	6.38 ms	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 = ? Parameters: [`30`] View formatted query View runnable query Explain query 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 = 30;
14	6.80 ms	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 = ? Parameters: [`31`] View formatted query View runnable query Explain query 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 = 31;
15	6.38 ms	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 = ? Parameters: [`15`] View formatted query View runnable query Explain query 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 = 15;
16	6.36 ms	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 = ? Parameters: [`34`] View formatted query View runnable query Explain query 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 = 34;
17	6.23 ms	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 = ? Parameters: [`18`] View formatted query View runnable query Explain query 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 = 18;
18	6.62 ms	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 = ? Parameters: [`51`] View formatted query View runnable query Explain query 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 = 51;
19	6.16 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
20	6.52 ms	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 = ? Parameters: [`20`] View formatted query View runnable query Explain query 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 = 20;
21	6.50 ms	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 = ? Parameters: [`5`] View formatted query View runnable query Explain query 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 = 5;
22	6.48 ms	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 = ? Parameters: [`17`] View formatted query View runnable query Explain query 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 = 17;
23	6.76 ms	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 = ? Parameters: [`7`] View formatted query View runnable query Explain query 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 = 7;
24	6.18 ms	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 = ? Parameters: [`40`] View formatted query View runnable query Explain query 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 = 40;
25	6.23 ms	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 = ? Parameters: [`25`] View formatted query View runnable query Explain query 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 = 25;
26	6.26 ms	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 = ? Parameters: [`8`] View formatted query View runnable query Explain query 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 = 8;
27	6.37 ms	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 = ? Parameters: [`9`] View formatted query View runnable query Explain query 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 = 9;
28	6.21 ms	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 = ? Parameters: [`42`] View formatted query View runnable query Explain query 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 = 42;
29	6.22 ms	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 = ? Parameters: [`26`] View formatted query View runnable query Explain query 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 = 26;
30	6.44 ms	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 = ? Parameters: [`10`] View formatted query View runnable query Explain query 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 = 10;
31	6.54 ms	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 = ? Parameters: [`43`] View formatted query View runnable query Explain query 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 = 43;
32	6.51 ms	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 = ? Parameters: [`27`] View formatted query View runnable query Explain query 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 = 27;
33	6.26 ms	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 = ? Parameters: [`11`] View formatted query View runnable query Explain query 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 = 11;
34	6.54 ms	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 = ? Parameters: [`44`] View formatted query View runnable query Explain query 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 = 44;
35	6.38 ms	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 = ? Parameters: [`28`] View formatted query View runnable query Explain query 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 = 28;
36	6.35 ms	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 = ? Parameters: [`12`] View formatted query View runnable query Explain query 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 = 12;
37	6.70 ms	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 = ? Parameters: [`45`] View formatted query View runnable query Explain query 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 = 45;
38	6.63 ms	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 = ? Parameters: [`46`] View formatted query View runnable query Explain query 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 = 46;
39	6.46 ms	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 = ? Parameters: [`14`] View formatted query View runnable query Explain query 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 = 14;
40	6.51 ms	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 = ? Parameters: [`47`] View formatted query View runnable query Explain query 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 = 47;
41	6.62 ms	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 = ? Parameters: [`32`] View formatted query View runnable query Explain query 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 = 32;
42	6.25 ms	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 = ? Parameters: [`48`] View formatted query View runnable query Explain query 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 = 48;
43	6.41 ms	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 = ? Parameters: [`33`] View formatted query View runnable query Explain query 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 = 33;
44	6.50 ms	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 = ? Parameters: [`16`] View formatted query View runnable query Explain query 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 = 16;
45	6.43 ms	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 = ? Parameters: [`49`] View formatted query View runnable query Explain query 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 = 49;
46	6.39 ms	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 = ? Parameters: [`19`] View formatted query View runnable query Explain query 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 = 19;
47	6.36 ms	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 = ? Parameters: [`52`] View formatted query View runnable query Explain query 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 = 52;
48	6.28 ms	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 = ? Parameters: [`21`] View formatted query View runnable query Explain query 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 = 21;
49	6.62 ms	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 = ? Parameters: [`53`] View formatted query View runnable query Explain query 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 = 53;
50	6.31 ms	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 = ? Parameters: [`3`] View formatted query View runnable query Explain query 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 = 3;
51	6.31 ms	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 = ? Parameters: [`37`] View formatted query View runnable query Explain query 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 = 37;
52	6.35 ms	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 = ? Parameters: [`22`] View formatted query View runnable query Explain query 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 = 22;
53	6.56 ms	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 = ? Parameters: [`54`] View formatted query View runnable query Explain query 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 = 54;
54	6.80 ms	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 = ? Parameters: [`38`] View formatted query View runnable query Explain query 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 = 38;
55	6.37 ms	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 = ? Parameters: [`23`] View formatted query View runnable query Explain query 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 = 23;
56	6.11 ms	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 = ? Parameters: [`55`] View formatted query View runnable query Explain query 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 = 55;
57	6.76 ms	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 = ? Parameters: [`6`] View formatted query View runnable query Explain query 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 = 6;
58	6.45 ms	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 = ? Parameters: [`39`] View formatted query View runnable query Explain query 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 = 39;
59	6.61 ms	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 = ? Parameters: [`50`] View formatted query View runnable query Explain query 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 = 50;
60	6.51 ms	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 = ? Parameters: [`35`] View formatted query View runnable query Explain query 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 = 35;
61	6.62 ms	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 = ? Parameters: [`36`] View formatted query View runnable query Explain query 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 = 36;
62	6.37 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
63	6.53 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM mapping_collection t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
64	7.32 ms	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 = ? Parameters: [`9`] View formatted query View runnable query Explain query 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;
65	6.84 ms	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 = ? Parameters: [`5`] View formatted query View runnable query Explain query 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;
66	7.18 ms	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 = ? Parameters: [`15`] View formatted query View runnable query Explain query 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 = 15;
67	6.39 ms	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 = ? Parameters: [`7`] View formatted query View runnable query Explain query 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 = 7;
68	6.81 ms	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 = ? Parameters: [`10`] View formatted query View runnable query Explain query 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 = 10;
69	6.24 ms	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 = ? Parameters: [`6`] View formatted query View runnable query Explain query 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 = 6;
70	6.82 ms	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 = ? Parameters: [`4`] View formatted query View runnable query Explain query 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 = 4;
71	6.63 ms	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 = ? Parameters: [`11`] View formatted query View runnable query Explain query 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 = 11;
72	6.73 ms	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 = ? Parameters: [`12`] View formatted query View runnable query Explain query 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 = 12;
73	6.53 ms	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 = ? Parameters: [`3`] View formatted query View runnable query Explain query 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 = 3;
74	6.40 ms	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 = ? Parameters: [`14`] View formatted query View runnable query Explain query 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 = 14;
75	6.23 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
76	7.02 ms	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 = ? Parameters: [`6`] View formatted query View runnable query Explain query 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 = 6;
77	6.56 ms	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 = ? Parameters: [`16`] View formatted query View runnable query Explain query 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 = 16;
78	6.14 ms	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 = ? Parameters: [`8`] View formatted query View runnable query Explain query 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 = 8;
79	6.48 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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 = 1;
80	6.65 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
81	6.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3 FROM mapping_collection t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query 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 = 2;
82	6.47 ms	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 Parameters: [`"ROLE_ADMIN"`] View formatted query View runnable query Explain query 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;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
urlappsalon	doctrine.dbal.urlappsalon_connection
sqlite	doctrine.dbal.sqlite_connection

Entity Managers

Name	Service
urlappsalon	doctrine.orm.urlappsalon_entity_manager
default	doctrine.orm.default_entity_manager
sqlite	doctrine.orm.sqlite_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

urlappsalon entity manager

Class	Amount of managed objects

default entity manager

Class	Amount of managed objects
App\Entity\Mapping	53
App\Entity\SubMapping	36
App\Entity\Field	36
App\Entity\DataProvider	12
App\Entity\Provider	5
App\Entity\MappingCollection	2
App\Entity\User	1
App\Entity\Salon	1
App\Entity\Organisateur	1
App\Entity\Chart	1
App\Entity\PacExpo	1
App\Entity\UserLog	1

sqlite entity manager

Class	Amount of managed objects

Entities Mapping

urlappsalon entity manager

No loaded entities.

default entity manager

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Salon	No errors.
App\Entity\Organisateur	No errors.
App\Entity\Chart	The mappings App\Entity\Chart#charteImages and App\Entity\ChartImage#chart are inconsistent with each other. The mappings App\Entity\Chart#charteLangues and App\Entity\ChartLangue#chart are inconsistent with each other.
App\Entity\PacExpo	No errors.
App\Entity\Dates	No errors.
App\Entity\Device	No errors.
App\Entity\SalonPage	No errors.
App\Entity\Role	No errors.
App\Entity\Mapping	No errors.
App\Entity\UserLog	No errors.
App\Entity\MappingCollection	No errors.
App\Entity\DataProvider	No errors.
App\Entity\Field	No errors.
App\Entity\Filter	No errors.
App\Entity\SubMapping	No errors.
App\Entity\ImportField	No errors.
App\Entity\MappingFile	No errors.
App\Entity\Provider	No errors.

sqlite entity manager

No loaded entities.

Symfony Profiler

GET https://sepemangers2025.appsalon.fr/easyadmin/mapping

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

urlappsalon entity manager

default entity manager

sqlite entity manager

Entities Mapping

urlappsalon entity manager

default entity manager

sqlite entity manager