http://dev.loger.cm/fr/announce/detail?announce=all

Query Metrics

8 Database Queries
6 Different statements
13.38 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.