GET https://preprod.ville-active.com-clients.fr/villes?page=12

Query Metrics

5 Database Queries
5 Different statements
6.29 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.46 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.presentation AS presentation_3, t0.image AS image_4, t0.image_alt AS image_alt_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keywords AS seo_keywords_8, t0.presentation_image AS presentation_image_9, t0.presentation_image_alt AS presentation_image_alt_10 FROM villes_labelisees_page t0 LIMIT 1
Parameters:
[]
2 1.02 ms
SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM ville_active v0_
Parameters:
[]
3 2.38 ms
SELECT DISTINCT v0_.id AS id_0, v0_.name AS name_1 FROM ville_active v0_ ORDER BY v0_.name ASC LIMIT 6 OFFSET 66
Parameters:
[]
4 0.83 ms
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.top_image AS top_image_2, v0_.site_link AS site_link_3, v0_.text AS text_4, v0_.coordinates AS coordinates_5, v0_.slug AS slug_6, v0_.top_image_alt AS top_image_alt_7, v0_.bottom_image AS bottom_image_8, v0_.bottom_image_alt AS bottom_image_alt_9, v0_.annee_label AS annee_label_10, v0_.departement_id AS departement_id_11, v0_.label_id AS label_id_12 FROM ville_active v0_ WHERE v0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY v0_.name ASC
Parameters:
[
  79
  80
  81
  82
  83
  84
]
5 0.60 ms
SELECT l0_.id AS id_0, l0_.slug AS slug_1, l0_.name AS name_2, l0_.image AS image_3 FROM label l0_
Parameters:
[]

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\VillesLabeliseesPage No errors.
App\Entity\Label No errors.
App\Entity\VilleActive No errors.
App\Entity\Departement No errors.