GET https://marchesreguliers.horai-software.com/french-market-day/36-market-day-indre.php

Query Metrics

28 Database Queries
6 Different statements
11.16 ms Query time
1 Invalid entities
201 Managed entities

Queries

Group similar statements

# Time Info
1 1.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.slug AS slug_4, t0.de_nom AS de_nom_5, t0.main_cities AS main_cities_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.region_id AS region_id_9 FROM department t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "36"
]
2 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.slug AS slug_4, t0.de_nom AS de_nom_5, t0.main_cities AS main_cities_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.region_id AS region_id_9 FROM department t0 ORDER BY t0.id ASC
Parameters:
[]
3 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.description_de AS description_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_es AS description_es_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9 FROM region_unofficial t0
Parameters:
[]
4 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM region t0 WHERE t0.id = ?
Parameters:
[
  4
]
5 1.07 ms
SELECT t0.id AS id_1, t0.weekday AS weekday_2, t0.time_from AS time_from_3, t0.time_to AS time_to_4, t0.note_periode AS note_periode_5, t0.note_hour AS note_hour_6, t0.link AS link_7, t0.link_available AS link_available_8, t0.legacy_city AS legacy_city_9, t0.legacy_adress AS legacy_adress_10, t0.description AS description_11, t0.periode_on AS periode_on_12, t0.slug_city AS slug_city_13, t0.location_id AS location_id_14, t0.legacy_dpt_id AS legacy_dpt_id_15, t0.city_id AS city_id_16 FROM market t0 WHERE t0.legacy_dpt_id = ?
Parameters:
[
  37
]
6 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14170
]
7 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14171
]
8 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14175
]
9 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14181
]
10 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14199
]
11 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14208
]
12 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14209
]
13 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14227
]
14 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14233
]
15 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14234
]
16 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14210
]
17 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14183
]
18 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14257
]
19 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14265
]
20 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14277
]
21 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14301
]
22 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14337
]
23 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14344
]
24 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14349
]
25 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14353
]
26 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14356
]
27 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14388
]
28 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_department AS legacy_department_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.website AS website_7, t0.departement_id AS departement_id_8 FROM city t0 WHERE t0.id = ?
Parameters:
[
  14392
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Department 105
App\Entity\Market 50
App\Entity\City 23
App\Entity\Region 22
App\Entity\RegionUnofficial 1

Entities Mapping

Class Mapping errors
App\Entity\Department No errors.
App\Entity\Region No errors.
App\Entity\City No errors.
App\Entity\Market No errors.
App\Entity\RegionUnofficial
  • The field App\Entity\RegionUnofficial#regionUnofficialMarkets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RegionUnofficialMarket#regionUnofficial does not contain the required 'inversedBy: "regionUnofficialMarkets"' attribute.
App\Entity\RegionUnofficialMarket No errors.
App\Entity\Location No errors.
App\Entity\ZipCode No errors.