Query Metrics
104
Database Queries
8
Different statements
54.77 ms
Query time
12
Invalid entities
89
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
26.24 ms (47.91%) |
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
]
|
|
7.31 ms (13.35%) |
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
]
|
|
6.60 ms (12.06%) |
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.18 ms (7.63%) |
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.04 ms (7.38%) |
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.52 ms (4.60%) |
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.40 ms (4.39%) |
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.47 ms (2.68%) |
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
| 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. |