Query Metrics
75
Database Queries
9
Different statements
8.09 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.23 ms (15.14%) |
9 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.measure AS measure_4, t0.equipment_id AS equipment_id_5 FROM equipment_additional_characteristic t0 WHERE t0.equipment_id = ?
Parameters:
[
43
]
|
1.20 ms (14.84%) |
9 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_alt AS image_alt_3, t0.image_description AS image_description_4, t0.image_title AS image_title_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.equipment_id AS equipment_id_8 FROM equipment_characteristic_image t0 WHERE t0.equipment_id = ?
Parameters:
[
43
]
|
1.12 ms (13.78%) |
14 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.filter AS filter_3, t0.measure AS measure_4 FROM characteristic t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.04 ms (12.87%) |
9 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_alt AS image_alt_3, t0.image_description AS image_description_4, t0.image_title AS image_title_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.equipment_id AS equipment_id_8 FROM equipment_gallery t0 WHERE t0.equipment_id = ?
Parameters:
[
43
]
|
0.88 ms (10.86%) |
9 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.characteristic_id AS characteristic_id_3, t0.equipment_id AS equipment_id_4 FROM equipment_characteristic t0 WHERE t0.equipment_id = ?
Parameters:
[
43
]
|
0.86 ms (10.61%) |
9 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_alt AS image_alt_3, t0.image_description AS image_description_4, t0.image_title AS image_title_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.equipment_id AS equipment_id_8 FROM equipment_image t0 WHERE t0.equipment_id = ?
Parameters:
[
43
]
|
0.83 ms (10.23%) |
6 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM equipment_category t0 WHERE t0.id = ?
Parameters:
[
3
]
|
0.76 ms (9.33%) |
9 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.diagonal AS diagonal_6, t0.characteristic_text AS characteristic_text_7, t0.title_bm AS title_bm_8, t0.price_on_request AS price_on_request_9, t0.category_id AS category_id_10, t0.parent_id AS parent_id_11 FROM equipment t0 WHERE t0.parent_id = ?
Parameters:
[
43
]
|
0.19 ms (2.34%) |
1 |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.price AS price_4, e0_.diagonal AS diagonal_5, e0_.characteristic_text AS characteristic_text_6, e0_.title_bm AS title_bm_7, e0_.price_on_request AS price_on_request_8, e0_.category_id AS category_id_9, e0_.parent_id AS parent_id_10 FROM equipment e0_ WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "43" "47" "52" "54" "58" "64" "69" "73" "75" ] |
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\Equipment |
|
App\Entity\EquipmentCategory | No errors. |
App\Entity\EquipmentImage | No errors. |
App\Entity\EquipmentCharacteristicImage | No errors. |
App\Entity\EquipmentCharacteristic | No errors. |
App\Entity\EquipmentAdditionalCharacteristic | No errors. |
App\Entity\EquipmentGallery | No errors. |
App\Entity\Characteristic | No errors. |