GET https://dev.citizens-reim.fr/product/5

Query Metrics

10 Database Queries
6 Different statements
6.39 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.address AS address_5, t0.completion_date AS completion_date_6, t0.furniture AS furniture_7, t0.budget_global AS budget_global_8, t0.unit_size AS unit_size_9, t0.unit_number AS unit_number_10, t0.zip_code AS zip_code_11, t0.city AS city_12, t0.urban AS urban_13, t0.service AS service_14, t0.works AS works_15, t0.purpose AS purpose_16, t0.senior AS senior_17, t0.virtual_tour_before AS virtual_tour_before_18, t0.virtual_tour_after AS virtual_tour_after_19, t0.total_size AS total_size_20, t0.key_number AS key_number_21, t0.size_per_resident AS size_per_resident_22, t0.type AS type_23, t0.citizen_id AS citizen_id_24, t0.configuration AS configuration_25, t0.sort AS sort_26, t0.furnish AS furnish_27, t0.amo AS amo_28, t0.sourcing AS sourcing_29, t0.act AS act_30 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
2 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 1.23 ms
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.product_id = ? AND p0_.gallery_id = ? ORDER BY p0_.sort ASC
Parameters:
[
  "5"
  1
]
4 0.85 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  89
  91
  84
  86
  90
  78
  79
  88
  80
  93
  81
  82
  85
  87
  83
  92
  94
  95
  96
  97
  98
]
5 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 0.58 ms
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.product_id = ? AND p0_.gallery_id = ? ORDER BY p0_.sort ASC
Parameters:
[
  "5"
  2
]
7 0.30 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (NULL)
Parameters:
[]
8 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = ?
Parameters:
[
  3
]
9 0.40 ms
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.product_id = ? AND p0_.gallery_id = ? ORDER BY p0_.sort ASC
Parameters:
[
  "5"
  3
]
10 0.38 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (?)
Parameters:
[
  1021
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Product
  • The association App\Entity\Product#categories refers to the owning side field App\Entity\ProductCategory#product which does not exist.
App\Entity\ProductGallery No errors.
App\Entity\ProductCategory No errors.
App\Entity\Gallery No errors.
App\Entity\GalleryImage No errors.