Query Metrics
8
Database Queries
6
Different statements
13.38 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.64 ms |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.location_type AS location_type_4, t0.amount AS amount_5, t0.number_of_piece AS number_of_piece_6, t0.area AS area_7, t0.description AS description_8, t0.created_at AS created_at_9, t0.expired_at AS expired_at_10, t0.vues AS vues_11, t0.description_en AS description_en_12, t0.type_id AS type_id_13, t0.address_id AS address_id_14, t0.picture_id AS picture_id_15, t0.cover_id AS cover_id_16, t0.created_by_id AS created_by_id_17 FROM announce t0 WHERE t0.id = ?
Parameters:
[
"all"
]
|
2 | 0.84 ms |
SELECT t0.id AS id_1, t0.new_title_fr AS new_title_fr_2, t0.content_fr AS content_fr_3, t0.content_en AS content_en_4, t0.content_es AS content_es_5, t0.publish AS publish_6, t0.created_at AS created_at_7, t0.new_title_en AS new_title_en_8, t0.new_title_es AS new_title_es_9, t0.liked AS liked_10, t0.unliked AS unliked_11, t0.created_by_id AS created_by_id_12, t0.cover_id AS cover_id_13, t0.picture1_id AS picture1_id_14, t0.picture2_id AS picture2_id_15 FROM actualite t0
Parameters:
[] |
3 | 5.87 ms |
SELECT t0.id AS id_1, t0.town_name AS town_name_2, t0.created_at AS created_at_3, t0.is_capital AS is_capital_4, t0.population AS population_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.region AS region_8, t0.vues AS vues_9, t0.country_id AS country_id_10, t0.picture_id AS picture_id_11 FROM town t0 ORDER BY t0.vues DESC
Parameters:
[] |
4 | 1.17 ms |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.location_type AS location_type_4, t0.amount AS amount_5, t0.number_of_piece AS number_of_piece_6, t0.area AS area_7, t0.description AS description_8, t0.created_at AS created_at_9, t0.expired_at AS expired_at_10, t0.vues AS vues_11, t0.description_en AS description_en_12, t0.type_id AS type_id_13, t0.address_id AS address_id_14, t0.picture_id AS picture_id_15, t0.cover_id AS cover_id_16, t0.created_by_id AS created_by_id_17 FROM announce t0
Parameters:
[] |
5 | 0.16 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.created_at AS created_at_3, t0.enable AS enable_4 FROM building_type t0
Parameters:
[] |
6 | 3.31 ms |
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.created_at AS created_at_3, t0.file_type AS file_type_4, t0.directory AS directory_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
282
]
|
7 | 0.21 ms |
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.created_at AS created_at_3, t0.file_type AS file_type_4, t0.directory AS directory_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
283
]
|
8 | 0.18 ms |
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.created_at AS created_at_3, t0.file_type AS file_type_4, t0.directory AS directory_5 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
286
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Announce | No errors. |
App\Entity\BuildingType | No errors. |
App\Entity\Address | No errors. |
App\Entity\MediaObject | No errors. |
App\Entity\User | No errors. |
App\Entity\Actualite | No errors. |
App\Entity\Commentaire | No errors. |
App\Entity\Visitor | No errors. |
App\Entity\Town | No errors. |
App\Entity\Country | No errors. |
App\Entity\AnnounceChannel | No errors. |
App\Entity\Building | No errors. |