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

Query Metrics

12 Database Queries
9 Different statements
20.13 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.74 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:
[
  "3"
]
2 1.95 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 6.55 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 0.57 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.46 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 8.76 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
]
7 0.24 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:
[
  284
]
8 0.23 ms
SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.phone_number AS phone_number_4, t0.email AS email_5, t0.password AS password_6, t0.roles AS roles_7, t0.active AS active_8, t0.salt AS salt_9, t0.email_canonical AS email_canonical_10, t0.plain_password AS plain_password_11, t0.confirmation_token AS confirmation_token_12, t0.password_requested_at AS password_requested_at_13, t0.username AS username_14, t0.last_login AS last_login_15, t0.enabled AS enabled_16, t0.username_canonical AS username_canonical_17, t0.is_verified AS is_verified_18, t0.local AS local_19, t0.login_in_count AS login_in_count_20, t0.resend_mail AS resend_mail_21, t0.created_at AS created_at_22, t0.update_at AS update_at_23, t0.user_picture_id AS user_picture_id_24, t0.company_id AS company_id_25, t0.address_id AS address_id_26 FROM user t0 WHERE t0.id = ?
Parameters:
[
  24
]
9 0.18 ms
SELECT t0.id AS id_1, t0.location AS location_2, t0.phone AS phone_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.town_id AS town_id_6 FROM address t0 WHERE t0.id = ?
Parameters:
[
  2
]
10 0.17 ms
SELECT t0.id AS id_1, t0.country_name AS country_name_2, t0.created_at AS created_at_3, t0.code AS code_4, t0.capital AS capital_5, t0.calling_code AS calling_code_6, t0.region AS region_7, t0.population AS population_8, t0.time_zone AS time_zone_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.offset AS offset_12, t0.country_flag_id AS country_flag_id_13 FROM country t0 WHERE t0.id = ?
Parameters:
[
  182
]
11 0.15 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
]
12 0.13 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
]

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\AnnounceChannel 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\Building No errors.
App\Entity\Company No errors.
App\Entity\Contact No errors.
App\Entity\Logs No errors.
App\Entity\Subscription No errors.
App\Entity\BookingRoom No errors.
App\Entity\Payment No errors.
App\Entity\AnnounceChat No errors.
App\Entity\PaymentOption No errors.
App\Entity\PaymentProvider No errors.