Query Metrics
104
Database Queries
8
Different statements
72.75 ms
Query time
12
Invalid entities
89
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.target AS target_3, t0.target_type AS target_type_4, t0.source_id AS source_id_5, t0.target_id AS target_id_6, t0.image_folder AS image_folder_7, t0.general_mapping AS general_mapping_8, t0.pagination AS pagination_9, t0.ordre AS ordre_10, t0.active AS active_11, t12.id AS id_13, t12.mapping_id AS mapping_id_14, t0.data_provider_id AS data_provider_id_15, t0.mapping_collection_id AS mapping_collection_id_16 FROM mapping t0 LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id WHERE t0.general_mapping = ?
Parameters:
[
1
]
|
| 2 | 0.71 ms |
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.name AS name_3, t0.data AS data_4, t0.data_text AS data_text_5, t0.mapping_from_file AS mapping_from_file_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.mapping_collection_id AS mapping_collection_id_9 FROM mapping_file t0 WHERE t0.identifiant = ? LIMIT 1
Parameters:
[
29
]
|
| 3 | 0.78 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
29
]
|
| 4 | 0.76 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
29
]
|
| 5 | 0.87 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.split_chunk AS split_chunk_22, t0.provider_id AS provider_id_23 FROM data_provider t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 6 | 0.69 ms |
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.name AS name_3, t0.data AS data_4, t0.data_text AS data_text_5, t0.mapping_from_file AS mapping_from_file_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.mapping_collection_id AS mapping_collection_id_9 FROM mapping_file t0 WHERE t0.identifiant = ? LIMIT 1
Parameters:
[
30
]
|
| 7 | 0.78 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
30
]
|
| 8 | 0.78 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
30
]
|
| 9 | 0.76 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.split_chunk AS split_chunk_22, t0.provider_id AS provider_id_23 FROM data_provider t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 10 | 0.72 ms |
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.name AS name_3, t0.data AS data_4, t0.data_text AS data_text_5, t0.mapping_from_file AS mapping_from_file_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.mapping_collection_id AS mapping_collection_id_9 FROM mapping_file t0 WHERE t0.identifiant = ? LIMIT 1
Parameters:
[
31
]
|
| 11 | 0.75 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
31
]
|
| 12 | 0.78 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
31
]
|
| 13 | 0.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.split_chunk AS split_chunk_22, t0.provider_id AS provider_id_23 FROM data_provider t0 WHERE t0.id = ?
Parameters:
[
12
]
|
| 14 | 0.85 ms |
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.name AS name_3, t0.data AS data_4, t0.data_text AS data_text_5, t0.mapping_from_file AS mapping_from_file_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.mapping_collection_id AS mapping_collection_id_9 FROM mapping_file t0 WHERE t0.identifiant = ? LIMIT 1
Parameters:
[
34
]
|
| 15 | 0.74 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
34
]
|
| 16 | 0.94 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
34
]
|
| 17 | 0.62 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
180
]
|
| 18 | 0.64 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
182
]
|
| 19 | 0.64 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
183
]
|
| 20 | 0.60 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
184
]
|
| 21 | 0.56 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
185
]
|
| 22 | 0.62 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
186
]
|
| 23 | 0.66 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
187
]
|
| 24 | 0.78 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.id = ?
Parameters:
[
23
]
|
| 25 | 0.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.target AS target_3, t0.target_type AS target_type_4, t0.source_id AS source_id_5, t0.target_id AS target_id_6, t0.image_folder AS image_folder_7, t0.general_mapping AS general_mapping_8, t0.pagination AS pagination_9, t0.ordre AS ordre_10, t0.active AS active_11, t12.id AS id_13, t12.mapping_id AS mapping_id_14, t0.data_provider_id AS data_provider_id_15, t0.mapping_collection_id AS mapping_collection_id_16 FROM mapping t0 LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id WHERE t0.id = ?
Parameters:
[
35
]
|
| 26 | 0.75 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
35
]
|
| 27 | 0.82 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
35
]
|
| 28 | 0.75 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
188
]
|
| 29 | 0.63 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
189
]
|
| 30 | 0.61 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
190
]
|
| 31 | 0.72 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.id = ?
Parameters:
[
24
]
|
| 32 | 0.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.target AS target_3, t0.target_type AS target_type_4, t0.source_id AS source_id_5, t0.target_id AS target_id_6, t0.image_folder AS image_folder_7, t0.general_mapping AS general_mapping_8, t0.pagination AS pagination_9, t0.ordre AS ordre_10, t0.active AS active_11, t12.id AS id_13, t12.mapping_id AS mapping_id_14, t0.data_provider_id AS data_provider_id_15, t0.mapping_collection_id AS mapping_collection_id_16 FROM mapping t0 LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id WHERE t0.id = ?
Parameters:
[
36
]
|
| 33 | 0.74 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
36
]
|
| 34 | 0.84 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
36
]
|
| 35 | 0.63 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
191
]
|
| 36 | 0.62 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
192
]
|
| 37 | 0.61 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
193
]
|
| 38 | 0.56 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
194
]
|
| 39 | 0.55 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
195
]
|
| 40 | 0.54 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
196
]
|
| 41 | 0.61 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
197
]
|
| 42 | 0.62 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
198
]
|
| 43 | 0.79 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.id = ?
Parameters:
[
25
]
|
| 44 | 0.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.target AS target_3, t0.target_type AS target_type_4, t0.source_id AS source_id_5, t0.target_id AS target_id_6, t0.image_folder AS image_folder_7, t0.general_mapping AS general_mapping_8, t0.pagination AS pagination_9, t0.ordre AS ordre_10, t0.active AS active_11, t12.id AS id_13, t12.mapping_id AS mapping_id_14, t0.data_provider_id AS data_provider_id_15, t0.mapping_collection_id AS mapping_collection_id_16 FROM mapping t0 LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id WHERE t0.id = ?
Parameters:
[
37
]
|
| 45 | 0.73 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
37
]
|
| 46 | 0.89 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
37
]
|
| 47 | 0.66 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
199
]
|
| 48 | 0.56 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
200
]
|
| 49 | 0.64 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
201
]
|
| 50 | 0.63 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
202
]
|
| 51 | 0.61 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
203
]
|
| 52 | 0.64 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
204
]
|
| 53 | 0.65 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
205
]
|
| 54 | 0.63 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
206
]
|
| 55 | 0.79 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.id = ?
Parameters:
[
26
]
|
| 56 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.target AS target_3, t0.target_type AS target_type_4, t0.source_id AS source_id_5, t0.target_id AS target_id_6, t0.image_folder AS image_folder_7, t0.general_mapping AS general_mapping_8, t0.pagination AS pagination_9, t0.ordre AS ordre_10, t0.active AS active_11, t12.id AS id_13, t12.mapping_id AS mapping_id_14, t0.data_provider_id AS data_provider_id_15, t0.mapping_collection_id AS mapping_collection_id_16 FROM mapping t0 LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id WHERE t0.id = ?
Parameters:
[
38
]
|
| 57 | 0.67 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
38
]
|
| 58 | 0.71 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
38
]
|
| 59 | 0.66 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
207
]
|
| 60 | 0.64 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
208
]
|
| 61 | 0.59 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
209
]
|
| 62 | 0.67 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
210
]
|
| 63 | 0.67 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
212
]
|
| 64 | 0.65 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
213
]
|
| 65 | 0.63 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
214
]
|
| 66 | 0.68 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.id = ?
Parameters:
[
27
]
|
| 67 | 0.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.target AS target_3, t0.target_type AS target_type_4, t0.source_id AS source_id_5, t0.target_id AS target_id_6, t0.image_folder AS image_folder_7, t0.general_mapping AS general_mapping_8, t0.pagination AS pagination_9, t0.ordre AS ordre_10, t0.active AS active_11, t12.id AS id_13, t12.mapping_id AS mapping_id_14, t0.data_provider_id AS data_provider_id_15, t0.mapping_collection_id AS mapping_collection_id_16 FROM mapping t0 LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id WHERE t0.id = ?
Parameters:
[
39
]
|
| 68 | 0.73 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
39
]
|
| 69 | 0.93 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
39
]
|
| 70 | 0.70 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
215
]
|
| 71 | 0.65 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
216
]
|
| 72 | 0.61 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
217
]
|
| 73 | 0.64 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
218
]
|
| 74 | 0.65 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
219
]
|
| 75 | 0.66 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
220
]
|
| 76 | 0.66 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
221
]
|
| 77 | 0.66 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
222
]
|
| 78 | 0.77 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.id = ?
Parameters:
[
28
]
|
| 79 | 0.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.target AS target_3, t0.target_type AS target_type_4, t0.source_id AS source_id_5, t0.target_id AS target_id_6, t0.image_folder AS image_folder_7, t0.general_mapping AS general_mapping_8, t0.pagination AS pagination_9, t0.ordre AS ordre_10, t0.active AS active_11, t12.id AS id_13, t12.mapping_id AS mapping_id_14, t0.data_provider_id AS data_provider_id_15, t0.mapping_collection_id AS mapping_collection_id_16 FROM mapping t0 LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id WHERE t0.id = ?
Parameters:
[
40
]
|
| 80 | 0.72 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
40
]
|
| 81 | 0.81 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
40
]
|
| 82 | 0.60 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
223
]
|
| 83 | 0.58 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
224
]
|
| 84 | 0.57 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
225
]
|
| 85 | 0.47 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
226
]
|
| 86 | 0.65 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
227
]
|
| 87 | 0.67 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
228
]
|
| 88 | 0.66 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
229
]
|
| 89 | 0.65 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
230
]
|
| 90 | 0.68 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
285
]
|
| 91 | 0.69 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
307
]
|
| 92 | 0.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.id = ?
Parameters:
[
36
]
|
| 93 | 0.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.target AS target_3, t0.target_type AS target_type_4, t0.source_id AS source_id_5, t0.target_id AS target_id_6, t0.image_folder AS image_folder_7, t0.general_mapping AS general_mapping_8, t0.pagination AS pagination_9, t0.ordre AS ordre_10, t0.active AS active_11, t12.id AS id_13, t12.mapping_id AS mapping_id_14, t0.data_provider_id AS data_provider_id_15, t0.mapping_collection_id AS mapping_collection_id_16 FROM mapping t0 LEFT JOIN sub_mapping t12 ON t12.mapping_id = t0.id WHERE t0.id = ?
Parameters:
[
49
]
|
| 94 | 0.72 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.mandatory AS mandatory_4, t0.empty AS empty_5, t0.accepted_values AS accepted_values_6, t0.not_accepted_values AS not_accepted_values_7 FROM filter t0 INNER JOIN mapping_filter ON t0.id = mapping_filter.filter_id WHERE mapping_filter.mapping_id = ?
Parameters:
[
49
]
|
| 95 | 0.83 ms |
SELECT t0.id AS id_1, t0.source AS source_2, t0.source_type AS source_type_3, t0.target AS target_4, t0.target_type AS target_type_5, t0.relation AS relation_6, t0.target_value AS target_value_7, t0.export AS export_8, t0.remove_old_join_enabled AS remove_old_join_enabled_9, t0.function AS function_10, t0.sub_mapping_id AS sub_mapping_id_11 FROM field t0 INNER JOIN mapping_field ON t0.id = mapping_field.field_id WHERE mapping_field.mapping_id = ?
Parameters:
[
49
]
|
| 96 | 0.68 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
308
]
|
| 97 | 0.64 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
309
]
|
| 98 | 0.64 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
310
]
|
| 99 | 0.70 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
311
]
|
| 100 | 0.64 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
312
]
|
| 101 | 0.61 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
313
]
|
| 102 | 0.48 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
314
]
|
| 103 | 0.58 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.id_exported_field AS id_exported_field_3, t0.field_id AS field_id_4 FROM import_field t0 WHERE t0.field_id = ?
Parameters:
[
315
]
|
| 104 | 0.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.split_chunk AS split_chunk_22, t0.provider_id AS provider_id_23 FROM data_provider t0 WHERE t0.id = ?
Parameters:
[
14
]
|
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\Field | 59 |
| App\Entity\Mapping | 11 |
| App\Entity\SubMapping | 7 |
| App\Entity\DataProvider | 4 |
| App\Entity\MappingFile | 4 |
| App\Entity\Provider | 2 |
| App\Entity\MappingCollection | 1 |
| App\Entity\Filter | 1 |
sqlite entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
urlappsalon entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\UrlAppSalon\Click | No errors. |
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Mapping | No errors. |
| App\Entity\SubMapping | No errors. |
| App\Entity\DataProvider | No errors. |
| App\Entity\MappingCollection | No errors. |
| App\Entity\Field | No errors. |
| App\Entity\Filter | No errors. |
| App\Entity\MappingFile | No errors. |
| App\Entity\Provider | No errors. |
| App\Entity\ImportField | No errors. |
| App\Entity\UrlAppSalon\Click | No errors. |
| App\Entity\Job | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\AppFilter | No errors. |
| App\Entity\ZoneGeoDev | No errors. |
| App\Entity\ProductRanking | No errors. |
| App\Entity\Translation | No errors. |
| App\Entity\ChartConfigWeb | No errors. |
| App\Entity\PacExpo | No errors. |
| App\Entity\BuildFile | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\TThematique | No errors. |
| App\Entity\Badge | No errors. |
| App\Entity\DeviceStat | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\UserLog | No errors. |
| App\Entity\Nomenclature | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Chart |
|
| App\Entity\TPays | No errors. |
| App\Entity\Commentaire | No errors. |
| App\Entity\Build | No errors. |
| App\Entity\ApportPerso | No errors. |
| App\Entity\SalonPage | No errors. |
| App\Entity\MapLegende | No errors. |
| App\Entity\ChartConfig | No errors. |
| App\Entity\DeltaCalculator | No errors. |
| App\Entity\TIntervenat | No errors. |
| App\Entity\BadgeExposant | No errors. |
| App\Entity\Dump | No errors. |
| App\Entity\Config | No errors. |
| App\Entity\ChartImage |
|
| App\Entity\Brand |
|
| App\Entity\ParcoursDirection | No errors. |
| App\Entity\TActivityArea | No errors. |
| App\Entity\TDevice | No errors. |
| App\Entity\ParcoursPOI |
|
| App\Entity\Entity | No errors. |
| App\Entity\QuizResult | No errors. |
| App\Entity\Societe | No errors. |
| App\Entity\Topic |
|
| App\Entity\ChartLangue | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ParcoursPicto |
|
| App\Entity\ChartStyleCssWeb | No errors. |
| App\Entity\THall | No errors. |
| App\Entity\Question | No errors. |
| App\Entity\Reponse | No errors. |
| App\Entity\ChartComponent | No errors. |
| App\Entity\Device | No errors. |
| App\Entity\TMap |
|
| App\Entity\Sync | No errors. |
| App\Entity\Vote | No errors. |
| App\Entity\ChartLangueWeb | No errors. |
| App\Entity\TInnovation |
|
| App\Entity\ChartImageList | No errors. |
| App\Entity\TExhibitors |
|
| App\Entity\Cronjob | No errors. |
| App\Entity\TExhibitionStand | No errors. |
| App\Entity\TSalle | No errors. |
| App\Entity\Visiteur | No errors. |
| App\Entity\Partenaire | No errors. |
| App\Entity\TMateriel | No errors. |
| App\Entity\ChartStyleCss | No errors. |
| App\Entity\TConferencetypeT | No errors. |
| App\Entity\TMapParcours | No errors. |
| App\Entity\SqlScript | No errors. |
| App\Entity\Dates | No errors. |
| App\Entity\Organisateur | No errors. |
| App\Entity\Salon | No errors. |
| App\Entity\Favorite |
|
| App\Entity\Token | No errors. |
| App\Entity\ChartImageWeb |
|
| App\Entity\TParticipanttype | No errors. |
| App\Entity\TAtelier |
|
| App\Entity\ServiceAlyse | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
| FOS\UserBundle\Model\User | No errors. |