GET https://marchesreguliers.horai-software.com/wochenmarkt/92-markttag-hauts-de-seine.php

Query Metrics

35 Database Queries
4 Different statements
12.18 ms Query time
0 Invalid entities
219 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:
[
  "92"
]
2 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM region t0 WHERE t0.id = ?
Parameters:
[
  11
]
3 1.52 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.legacy_city AS legacy_city_8, t0.legacy_adress AS legacy_adress_9, t0.description AS description_10, t0.periode_on AS periode_on_11, t0.location_id AS location_id_12, t0.legacy_dpt_id AS legacy_dpt_id_13, t0.city_id AS city_id_14 FROM market t0 WHERE t0.legacy_dpt_id = ?
Parameters:
[
  92
]
4 0.48 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:
[
  36285
]
5 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:
[
  36287
]
6 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:
[
  36288
]
7 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:
[
  36289
]
8 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:
[
  36290
]
9 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:
[
  36291
]
10 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:
[
  36292
]
11 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:
[
  36293
]
12 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:
[
  36294
]
13 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:
[
  36296
]
14 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:
[
  36297
]
15 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:
[
  36298
]
16 0.23 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:
[
  36299
]
17 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:
[
  36301
]
18 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:
[
  36302
]
19 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:
[
  36300
]
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:
[
  36310
]
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:
[
  36303
]
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:
[
  36304
]
23 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:
[
  36306
]
24 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:
[
  36307
]
25 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:
[
  36308
]
26 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:
[
  36309
]
27 0.24 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:
[
  36311
]
28 0.24 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:
[
  36312
]
29 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:
[
  36313
]
30 0.22 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:
[
  36314
]
31 0.22 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:
[
  36315
]
32 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:
[
  36316
]
33 0.23 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:
[
  36317
]
34 0.24 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:
[
  36318
]
35 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:
[
  36320
]

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\Market 185
App\Entity\City 32
App\Entity\Department 1
App\Entity\Region 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\Location No errors.
App\Entity\ZipCode No errors.