GET https://marchesreguliers.horai-software.com/french-market-day/30-market-day-gard.php

Query Metrics

110 Database Queries
6 Different statements
38.14 ms Query time
1 Invalid entities
406 Managed entities

Queries

Group similar statements

# Time Info
1 1.21 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:
[
  "30"
]
2 0.69 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.45 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.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:
[
  12
]
5 1.53 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:
[
  31
]
6 0.86 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:
[
  11525
]
7 0.34 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:
[
  11528
]
8 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:
[
  11529
]
9 0.56 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:
[
  11530
]
10 0.46 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:
[
  11532
]
11 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:
[
  11534
]
12 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:
[
  11541
]
13 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:
[
  11546
]
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:
[
  11550
]
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:
[
  11551
]
16 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:
[
  11554
]
17 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:
[
  11556
]
18 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:
[
  11558
]
19 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:
[
  11559
]
20 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:
[
  11561
]
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:
[
  11569
]
22 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:
[
  11564
]
23 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:
[
  11574
]
24 0.57 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:
[
  11582
]
25 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:
[
  11584
]
26 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:
[
  11589
]
27 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:
[
  11596
]
28 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:
[
  11600
]
29 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:
[
  11602
]
30 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:
[
  11603
]
31 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:
[
  11604
]
32 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:
[
  11605
]
33 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:
[
  11607
]
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:
[
  11609
]
35 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:
[
  11612
]
36 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:
[
  11615
]
37 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:
[
  11622
]
38 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:
[
  11623
]
39 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:
[
  11625
]
40 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:
[
  11627
]
41 0.67 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:
[
  11637
]
42 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:
[
  11639
]
43 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:
[
  11642
]
44 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:
[
  11644
]
45 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:
[
  11647
]
46 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:
[
  11648
]
47 0.34 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:
[
  11649
]
48 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:
[
  11650
]
49 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:
[
  11583
]
50 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:
[
  11651
]
51 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:
[
  11659
]
52 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:
[
  11581
]
53 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:
[
  11652
]
54 0.58 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:
[
  11869
]
55 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:
[
  11664
]
56 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:
[
  11665
]
57 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:
[
  11671
]
58 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:
[
  11674
]
59 0.53 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:
[
  11675
]
60 0.43 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:
[
  11683
]
61 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:
[
  11685
]
62 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:
[
  11687
]
63 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:
[
  11688
]
64 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:
[
  11690
]
65 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:
[
  11691
]
66 0.45 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:
[
  11694
]
67 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:
[
  11697
]
68 0.34 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:
[
  11698
]
69 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:
[
  11703
]
70 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:
[
  11704
]
71 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:
[
  11708
]
72 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:
[
  11710
]
73 0.37 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:
[
  11721
]
74 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:
[
  11725
]
75 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:
[
  11728
]
76 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:
[
  11729
]
77 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:
[
  11730
]
78 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:
[
  11731
]
79 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:
[
  11736
]
80 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:
[
  11875
]
81 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:
[
  11740
]
82 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:
[
  11742
]
83 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:
[
  11746
]
84 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:
[
  11750
]
85 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:
[
  11760
]
86 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:
[
  11777
]
87 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:
[
  11782
]
88 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:
[
  11787
]
89 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:
[
  11788
]
90 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:
[
  11797
]
91 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:
[
  11814
]
92 0.47 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:
[
  11821
]
93 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:
[
  11824
]
94 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:
[
  11830
]
95 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:
[
  11834
]
96 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:
[
  11836
]
97 0.37 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:
[
  11840
]
98 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:
[
  11841
]
99 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:
[
  11843
]
100 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:
[
  11844
]
101 0.34 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:
[
  11845
]
102 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:
[
  11847
]
103 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:
[
  11852
]
104 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:
[
  11853
]
105 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:
[
  11855
]
106 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:
[
  11858
]
107 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:
[
  11860
]
108 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:
[
  11863
]
109 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:
[
  11867
]
110 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:
[
  11870
]

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 173
App\Entity\Department 105
App\Entity\City 105
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.