Query Metrics
10
Database Queries
5
Different statements
5.87 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.19 ms (37.35%) |
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:
[ "14" 1 ]
|
||||||||||||||||||||||||||||||
|
1.28 ms (21.87%) |
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
]
|
||||||||||||||||||||||||||||||
|
0.98 ms (16.79%) |
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:
[
"14"
]
|
||||||||||||||||||||||||||||||
|
0.89 ms (15.17%) |
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:
[ 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 ]
|
||||||||||||||||||||||||||||||
|
0.52 ms (8.83%) |
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:
[
162
]
|
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 |
|
| App\Entity\ProductGallery | No errors. |
| App\Entity\ProductCategory | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\GalleryImage | No errors. |