GET https://api.itlabs.top/api/equipments/

Query Metrics

75 Database Queries
9 Different statements
8.68 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.33 ms
(15.28%)
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.30 ms
(14.98%)
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.15 ms
(13.22%)
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.07 ms
(12.31%)
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
]
1.06 ms
(12.20%)
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.98 ms
(11.28%)
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.85 ms
(9.74%)
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.77 ms
(8.81%)
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.18%)
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
  • The mappings App\Entity\Equipment#additionalCharacteristics and App\Entity\EquipmentAdditionalCharacteristic#equipment are inconsistent with each other.
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.