GET https://marchesreguliers.horai-software.com/french-market-day/11-market-day-aude.php

Query Metrics

33 Database Queries
6 Different statements
11.90 ms Query time
1 Invalid entities
238 Managed entities

Queries

Group similar statements

# Time Info
1 1.31 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:
[
  "11"
]
2 0.62 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.33 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.48 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 0.68 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:
[
  11
]
6 0.69 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:
[
  3671
]
7 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:
[
  3684
]
8 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:
[
  3711
]
9 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:
[
  3703
]
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:
[
  3731
]
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:
[
  3738
]
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:
[
  3743
]
13 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:
[
  3768
]
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:
[
  3791
]
15 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:
[
  3794
]
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:
[
  3802
]
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:
[
  3807
]
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:
[
  3826
]
19 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:
[
  3832
]
20 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:
[
  3847
]
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:
[
  3864
]
22 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:
[
  3865
]
23 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:
[
  3868
]
24 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:
[
  3918
]
25 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:
[
  3923
]
26 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:
[
  3930
]
27 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:
[
  3927
]
28 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:
[
  3965
]
29 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:
[
  4026
]
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:
[
  4027
]
31 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:
[
  4039
]
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:
[
  4057
]
33 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:
[
  4092
]

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 82
App\Entity\City 28
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.