GET https://marchesreguliers.horai-software.com/wochenmarkt/02-markttag-aisne.php

Query Metrics

55 Database Queries
4 Different statements
16.30 ms Query time
0 Invalid entities
124 Managed entities

Queries

Group similar statements

# Time Info
1 1.11 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:
[
  "02"
]
2 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM region t0 WHERE t0.id = ?
Parameters:
[
  17
]
3 0.60 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:
[
  2
]
4 0.41 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:
[
  437
]
5 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:
[
  450
]
6 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:
[
  477
]
7 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:
[
  510
]
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:
[
  512
]
9 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:
[
  520
]
10 0.36 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:
[
  523
]
11 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:
[
  527
]
12 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:
[
  579
]
13 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:
[
  584
]
14 0.42 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:
[
  589
]
15 0.35 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:
[
  602
]
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:
[
  595
]
17 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:
[
  618
]
18 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:
[
  624
]
19 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:
[
  632
]
20 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:
[
  652
]
21 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:
[
  708
]
22 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:
[
  711
]
23 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:
[
  717
]
24 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:
[
  729
]
25 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:
[
  745
]
26 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:
[
  751
]
27 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:
[
  771
]
28 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:
[
  791
]
29 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:
[
  557
]
30 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:
[
  716
]
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:
[
  719
]
32 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:
[
  817
]
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:
[
  965
]
34 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:
[
  839
]
35 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:
[
  875
]
36 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:
[
  872
]
37 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:
[
  876
]
38 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:
[
  909
]
39 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:
[
  907
]
40 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:
[
  950
]
41 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:
[
  981
]
42 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:
[
  1014
]
43 0.39 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:
[
  1052
]
44 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:
[
  1072
]
45 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:
[
  1081
]
46 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:
[
  1095
]
47 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:
[
  1112
]
48 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:
[
  1122
]
49 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:
[
  1124
]
50 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:
[
  1140
]
51 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:
[
  1160
]
52 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:
[
  1178
]
53 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:
[
  1191
]
54 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:
[
  1197
]
55 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:
[
  1212
]

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 70
App\Entity\City 52
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.