GET https://alifcart.com/item/2

Query Metrics

17 Database Queries
5 Different statements
14.91 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.92 ms
(46.44%)
5
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.product_id AS product_id_3, t0.user_id AS user_id_4, t0.channel_id AS channel_id_5 FROM inventory t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
3.21 ms
(21.53%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.sku AS sku_4, t0.cogs AS cogs_5, t0.price AS price_6, t0.tracked AS tracked_7, t0.enable AS enable_8, t0.parent_id AS parent_id_9, t0.category_id AS category_id_10, t0.unit_id AS unit_id_11, t0.brand_id AS brand_id_12, t0.discount_id AS discount_id_13 FROM inventory__product t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
2.65 ms
(17.77%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumbnail AS thumbnail_3, t0.description AS description_4, t0.width AS width_5, t0.height AS height_6, t0.content_type AS content_type_7, t0.path AS path_8, t0.temp AS temp_9, t10.lname AS lname_11, t10.profession AS profession_12, t10.id AS id_13, t10.name AS name_14, t10.gender AS gender_15, t10.dob AS dob_16, t10.enable AS enable_17, t10.marital_status AS marital_status_18, t10.type AS type_19, t10.created AS created_20, t10.updated AS updated_21, t10.account_id AS account_id_22, t10.permanent_address_id AS permanent_address_id_23, t10.media_id AS media_id_24, t10.user_id AS user_id_25, t10.address_id AS address_id_26, t10.photo_id AS photo_id_27 FROM media__media t0 LEFT JOIN profile__person t10 ON t10.media_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
1.68 ms
(11.29%)
5
SELECT t0.id AS id_1, t0.position AS position_2, t0.product_id AS product_id_3, t0.media_id AS media_id_4 FROM inventory__product_media t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
0.44 ms
(2.98%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.sku AS sku_4, t0.cogs AS cogs_5, t0.price AS price_6, t0.tracked AS tracked_7, t0.enable AS enable_8, t0.parent_id AS parent_id_9, t0.category_id AS category_id_10, t0.unit_id AS unit_id_11, t0.brand_id AS brand_id_12, t0.discount_id AS discount_id_13 FROM inventory__product t0 WHERE t0.parent_id = ?
Parameters:
[
  2
]

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.