Query Metrics
143
Database Queries
13
Different statements
1854.04 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
764.08 ms (41.21%) |
59 |
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:
[
"karen"
]
|
601.71 ms (32.45%) |
47 |
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" "1f086777-3b89-6562-aa60-4d4d91c0681a" ] |
156.88 ms (8.46%) |
12 |
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:
[
"1f088f71-210c-6bcc-a05e-a15fe4c86aca"
]
|
78.30 ms (4.22%) |
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:
[
"1f088f71-084c-60ec-a668-a15fe4c86aca"
]
|
77.47 ms (4.18%) |
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:
[
"1f088f71-084c-60ec-a668-a15fe4c86aca"
]
|
52.46 ms (2.83%) |
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.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 "1f086777-3b89-6562-aa60-4d4d91c0681a" ] |
39.27 ms (2.12%) |
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.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:
[
"1f088f71-210c-647e-814e-a15fe4c86aca"
]
|
15.38 ms (0.83%) |
1 |
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_ INNER JOIN product_category_product p2_ ON p0_.id = p2_.product_id INNER JOIN product_category p1_ ON p1_.id = p2_.product_category_id INNER JOIN website w3_ ON p0_.website_id = w3_.id WHERE p0_.active = 1 AND p1_.id = ? AND w3_.id = ? AND p0_.deleted_at IS NULL AND p0_.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ "1f088f71-084b-68ea-b545-a15fe4c86aca" "1f086777-3b89-6562-aa60-4d4d91c0681a" "1f088f71-084c-60ec-a668-a15fe4c86aca" "1f088f71-11e3-657e-bf39-a15fe4c86aca" "1f088f71-14f4-61dc-b8f0-a15fe4c86aca" "1f088f71-178c-61a6-a14d-a15fe4c86aca" "1f088f71-1b34-6ea2-9d70-a15fe4c86aca" "1f088f71-1e35-6bd8-ad08-a15fe4c86aca" ] |
14.91 ms (0.80%) |
1 |
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ INNER JOIN product_category_product p2_ ON p0_.id = p2_.product_id INNER JOIN product_category p1_ ON p1_.id = p2_.product_category_id INNER JOIN website w3_ ON p0_.website_id = w3_.id WHERE p0_.active = 1 AND p1_.id = ? AND w3_.id = ? AND p0_.deleted_at IS NULL LIMIT 20
Parameters:
[ "1f088f71-084b-68ea-b545-a15fe4c86aca" "1f086777-3b89-6562-aa60-4d4d91c0681a" ] |
13.82 ms (0.75%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category_product p2_ ON p0_.id = p2_.product_id INNER JOIN product_category p1_ ON p1_.id = p2_.product_category_id INNER JOIN website w3_ ON p0_.website_id = w3_.id WHERE p0_.active = 1 AND p1_.id = ? AND w3_.id = ? AND p0_.deleted_at IS NULL
Parameters:
[ "1f088f71-084b-68ea-b545-a15fe4c86aca" "1f086777-3b89-6562-aa60-4d4d91c0681a" ] |
13.81 ms (0.74%) |
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.url_slug = ? LIMIT 1
Parameters:
[
"slug-68b88e4c5faa299232800"
]
|
13.05 ms (0.70%) |
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" ] |
12.91 ms (0.70%) |
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.