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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 3.21 ms
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 5.96 ms
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 0.68 ms
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
]
4 0.99 ms
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
]
5 0.44 ms
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
]
6 0.26 ms
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:
[
  48
]
7 0.28 ms
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:
[
  48
]
8 0.75 ms
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:
[
  9
]
9 0.25 ms
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:
[
  49
]
10 0.21 ms
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:
[
  49
]
11 0.37 ms
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:
[
  10
]
12 0.22 ms
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:
[
  50
]
13 0.20 ms
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:
[
  50
]
14 0.25 ms
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:
[
  11
]
15 0.23 ms
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:
[
  51
]
16 0.31 ms
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:
[
  51
]
17 0.29 ms
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:
[
  8
]

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.