GET https://www.lipsom.lizii.fr/advert/

Query Metrics

7 Database Queries
3 Different statements
3.87 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.76 ms
SELECT a0_.id AS id_0, a0_.advert_name AS advert_name_1, a0_.advert_location AS advert_location_2, a0_.advert_pieces AS advert_pieces_3, a0_.advert_sale AS advert_sale_4, a0_.advert_description AS advert_description_5, a0_.advert_date AS advert_date_6, a0_.advert_living_space AS advert_living_space_7, a0_.advert_total_surface AS advert_total_surface_8, a0_.advert_rent_alone AS advert_rent_alone_9, a0_.advert_rent_charges AS advert_rent_charges_10, a0_.advert_type_id AS advert_type_id_11, a0_.advert_photo_id AS advert_photo_id_12, a0_.advert_user_id AS advert_user_id_13 FROM advert a0_ ORDER BY a0_.advert_date DESC, a0_.advert_sale ASC
Parameters:
[]
2 0.62 ms
SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = ?
Parameters:
[
  35
]
3 0.33 ms
SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.66 ms
SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = ?
Parameters:
[
  4
]
5 0.34 ms
SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = ?
Parameters:
[
  4
]
6 0.86 ms
SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = ?
Parameters:
[
  3
]
7 0.30 ms
SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = ?
Parameters:
[
  3
]

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\Advert No errors.
App\Entity\Type No errors.
App\Entity\Photo No errors.
App\Entity\User No errors.
App\Entity\Favorite No errors.
App\Entity\FileSend No errors.
App\Entity\Excluded No errors.