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

Query Metrics

10 Database Queries
5 Different statements
5.87 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 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:
[
  "14"
]
2 0.67 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.11 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:
[
  "14"
  1
]
4 0.89 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:
[
  147
  146
  150
  149
  148
  151
  152
  154
  155
  153
  157
  158
  156
  159
  161
  160
  164
  163
  165
  167
  168
  166
  171
  169
  170
  172
  174
  173
  175
  177
  176
  179
  178
  180
]
5 0.39 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:
[
  "14"
  2
]
7 0.26 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:
[
  162
]
8 0.23 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.51 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:
[
  "14"
  3
]
10 0.26 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:
[
  1024
]

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.