GET https://dev.crea-card.com/emplacements/alberes/office-du-tourisme-st-genis-des-fontaines

Query Metrics

3 Database Queries
3 Different statements
2.91 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM sector t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "alberes"
]
2 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.secteur_id AS secteur_id_9, t10.id AS id_11, t10.name AS name_12, t10.slug AS slug_13, t0.city_id AS city_id_14, t15.id AS id_16, t15.name AS name_17, t15.slug AS slug_18, t15.zipcode AS zipcode_19 FROM emplacement t0 INNER JOIN sector t10 ON t0.secteur_id = t10.id INNER JOIN city t15 ON t0.city_id = t15.id WHERE t0.secteur_id = ?
Parameters:
[
  1
]
3 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.secteur_id AS secteur_id_9, t10.id AS id_11, t10.name AS name_12, t10.slug AS slug_13, t0.city_id AS city_id_14, t15.id AS id_16, t15.name AS name_17, t15.slug AS slug_18, t15.zipcode AS zipcode_19 FROM emplacement t0 INNER JOIN sector t10 ON t0.secteur_id = t10.id INNER JOIN city t15 ON t0.city_id = t15.id WHERE t0.slug = ? AND t0.secteur_id = ? LIMIT 1
Parameters:
[
  "office-du-tourisme-st-genis-des-fontaines"
  1
]

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\Sector No errors.
App\Entity\Emplacement No errors.
App\Entity\City No errors.
App\Entity\Customer No errors.