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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
2.07 ms
(35.01%)
3
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:
[
  "75"
  1
]
1.26 ms
(21.36%)
3
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
]
1.13 ms
(19.15%)
1
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:
[
  "75"
]
0.79 ms
(13.29%)
2
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:
[
  838
]
0.66 ms
(11.19%)
1
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:
[
  822
  825
  823
  824
  827
  826
  828
  829
  830
  831
  833
  832
  835
  834
  837
  836
]

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.