Query Metrics
198
Database Queries
15
Different statements
2112.06 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
753.15 ms (35.66%) |
71 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.subdomain AS subdomain_10, t0.shop_balance AS shop_balance_11, t0.theme AS theme_12, t0.analytics_data AS analytics_data_13, t0.expired_at AS expired_at_14, t0.traffic_usage AS traffic_usage_15, t0.plan_started_at AS plan_started_at_16, t0.owner_id AS owner_id_17, t0.current_plan_id AS current_plan_id_18 FROM website t0 WHERE t0.subdomain = ? LIMIT 1
Parameters:
[
"default"
]
|
442.00 ms (20.93%) |
42 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.value AS value_10, t0.website_id AS website_id_11 FROM `shop_setting` t0 WHERE t0.name = ? AND t0.website_id = ? LIMIT 1
Parameters:
[ "seo_general_siteName" "1f08677f-ceae-6d44-99f4-1f13608c82a4" ] |
276.65 ms (13.10%) |
26 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.value AS value_10, t0.post_type_id AS post_type_id_11 FROM post_type_meta t0 WHERE t0.post_type_id = ? AND t0.name = ? AND t0.active = ? LIMIT 1
Parameters:
[ "1f088f72-b0dd-6282-a528-8322abf83007" "image" 1 ] |
169.13 ms (8.01%) |
16 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.label AS label_9, t0.url AS url_10, t0.menu_item_order AS menu_item_order_11, t0.type AS type_12, t0.target AS target_13, t0.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
"1f088f72-cbda-6fa8-93d7-8322abf83007"
]
|
76.83 ms (3.64%) |
7 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.stock AS stock_9, t0.name AS name_10, t0.description AS description_11, t0.price AS price_12, t0.image_url AS image_url_13, t0.sub_name AS sub_name_14, t0.is_selling AS is_selling_15, t0.publish_status AS publish_status_16, t0.sku AS sku_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.canonical_url AS canonical_url_21, t0.robots AS robots_22, t0.og_title AS og_title_23, t0.og_image_path AS og_image_path_24, t0.twitter_card_type AS twitter_card_type_25, t0.extra_seo_data AS extra_seo_data_26, t0.website_id AS website_id_27 FROM product t0 INNER JOIN product_category_product ON t0.id = product_category_product.product_id WHERE product_category_product.product_category_id = ?
Parameters:
[
"1f088f72-b0e6-69cc-a4b1-8322abf83007"
]
|
66.37 ms (3.14%) |
6 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.description AS description_10, t0.image_url AS image_url_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keywords AS meta_keywords_14, t0.canonical_url AS canonical_url_15, t0.robots AS robots_16, t0.og_title AS og_title_17, t0.og_image_path AS og_image_path_18, t0.twitter_card_type AS twitter_card_type_19, t0.extra_seo_data AS extra_seo_data_20, t0.website_id AS website_id_21, t0.parent_id AS parent_id_22 FROM product_category t0 INNER JOIN product_category_product ON t0.id = product_category_product.product_category_id WHERE product_category_product.product_id = ?
Parameters:
[
"1f088f72-b0e8-652e-a082-8322abf83007"
]
|
63.49 ms (3.01%) |
6 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.image_url AS image_url_9, t0.product_id AS product_id_10 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
"1f088f72-b0e8-652e-a082-8322abf83007"
]
|
62.43 ms (2.96%) |
6 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.in_stock AS in_stock_9, t0.price AS price_10, t0.product_id AS product_id_11 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
"1f088f72-b0e8-652e-a082-8322abf83007"
]
|
54.06 ms (2.56%) |
5 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.position AS position_9, t0.title AS title_10, t0.website_id AS website_id_11 FROM menu t0 WHERE t0.position = ? AND t0.active = ? AND t0.website_id = ? LIMIT 1
Parameters:
[ "headerMenu" 1 "1f08677f-ceae-6d44-99f4-1f13608c82a4" ] |
44.25 ms (2.09%) |
4 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.label AS label_9, t0.url AS url_10, t0.menu_item_order AS menu_item_order_11, t0.type AS type_12, t0.target AS target_13, t0.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM menu_item t0 WHERE t0.menu_id = ?
Parameters:
[
"1f088f72-cbda-697c-9a56-8322abf83007"
]
|
35.62 ms (1.69%) |
3 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.post_type AS post_type_9, t0.theme_slug AS theme_slug_10, t0.website_id AS website_id_11 FROM post_type t0 WHERE t0.website_id = ? AND t0.post_type = ? AND t0.active = ? LIMIT 10
Parameters:
[ "1f08677f-ceae-6d44-99f4-1f13608c82a4" "slider" 1 ] |
34.13 ms (1.62%) |
3 |
SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.deleted_at AS deleted_at_2, p0_.uuid AS uuid_3, p0_.url_slug AS url_slug_4, p0_.og_description AS og_description_5, p0_.active AS active_6, p0_.id AS id_7, p0_.stock AS stock_8, p0_.name AS name_9, p0_.description AS description_10, p0_.price AS price_11, p0_.image_url AS image_url_12, p0_.sub_name AS sub_name_13, p0_.is_selling AS is_selling_14, p0_.publish_status AS publish_status_15, p0_.sku AS sku_16, p0_.meta_title AS meta_title_17, p0_.meta_description AS meta_description_18, p0_.meta_keywords AS meta_keywords_19, p0_.canonical_url AS canonical_url_20, p0_.robots AS robots_21, p0_.og_title AS og_title_22, p0_.og_image_path AS og_image_path_23, p0_.twitter_card_type AS twitter_card_type_24, p0_.extra_seo_data AS extra_seo_data_25, p0_.website_id AS website_id_26 FROM product p0_ WHERE p0_.website_id = ? AND p0_.deleted_at IS NULL AND p0_.active = 1 AND (p0_.publish_status IS NULL OR p0_.publish_status = ?) LIMIT 10
Parameters:
[ "1f08677f-ceae-6d44-99f4-1f13608c82a4" "published" ] |
11.50 ms (0.54%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.description AS description_10, t0.image_url AS image_url_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keywords AS meta_keywords_14, t0.canonical_url AS canonical_url_15, t0.robots AS robots_16, t0.og_title AS og_title_17, t0.og_image_path AS og_image_path_18, t0.twitter_card_type AS twitter_card_type_19, t0.extra_seo_data AS extra_seo_data_20, t0.website_id AS website_id_21, t0.parent_id AS parent_id_22 FROM product_category t0 WHERE t0.active = ? AND t0.deleted_at IS NULL AND t0.website_id = ?
Parameters:
[ 1 "1f08677f-ceae-6d44-99f4-1f13608c82a4" ] |
11.25 ms (0.53%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.shipping_cost AS shipping_cost_9, t0.tax_amount AS tax_amount_10, t0.total_price AS total_price_11, t0.tracking_code AS tracking_code_12, t0.payment_gateway AS payment_gateway_13, t0.note AS note_14, t0.paid_at AS paid_at_15, t0.is_paid AS is_paid_16, t0.customer_id AS customer_id_17, t0.status_id AS status_id_18, t0.shipping_method_id AS shipping_method_id_19, t0.website_id AS website_id_20, t0.coupon_id AS coupon_id_21, t0.address_id AS address_id_22 FROM `order` t0 WHERE t0.customer_id IS NULL AND t0.active = ? AND t0.deleted_at IS NULL AND t0.status_id = ? LIMIT 1
Parameters:
[ 1 "1f080ffa-370c-67e8-bb49-774dac25365e" ] |
11.20 ms (0.53%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.code AS code_10 FROM order_status t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"cart"
]
|
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.