Query Metrics
104
Database Queries
8
Different statements
67.87 ms
Query time
0
Invalid entities
89
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
34.76 ms (51.22%) |
59 |
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
]
|
|
8.78 ms (12.93%) |
11 |
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
]
|
|
7.63 ms (11.25%) |
11 |
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.60 ms (6.78%) |
7 |
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
]
|
|
4.60 ms (6.78%) |
7 |
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
]
|
|
2.99 ms (4.41%) |
4 |
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
]
|
|
2.73 ms (4.02%) |
4 |
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
]
|
|
1.77 ms (2.61%) |
1 |
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
]
|
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
No loaded entities.
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. |
sqlite entity manager
No loaded entities.