Query Metrics
12
Database Queries
9
Different statements
7.50 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.77 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:
[
"2"
]
|
2 | 0.34 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 | 4.25 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.41 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.14 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 | 0.37 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
]
|
7 | 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:
[
1
]
|
8 | 0.29 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.29 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.18 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.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:
[
282
]
|
12 | 0.14 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\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. |