Query Metrics
204
Database Queries
15
Different statements
3212.14 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1399.90 ms (43.58%) |
89 |
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"
]
|
812.02 ms (25.28%) |
52 |
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" ] |
347.62 ms (10.82%) |
22 |
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:
[ "1f088f71-0841-6fac-a3a7-a15fe4c86aca" "image" 1 ] |
185.39 ms (5.77%) |
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"
]
|
97.37 ms (3.03%) |
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-1e35-6bd8-ad08-a15fe4c86aca"
]
|
96.06 ms (2.99%) |
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-1e35-6bd8-ad08-a15fe4c86aca"
]
|
62.82 ms (1.96%) |
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" ] |
48.36 ms (1.51%) |
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:
[ "1f086777-3b89-6562-aa60-4d4d91c0681a" "slider" 1 ] |
47.70 ms (1.48%) |
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"
]
|
33.28 ms (1.04%) |
2 |
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 = ?) ORDER BY p0_.id DESC LIMIT 10
Parameters:
[ "1f086777-3b89-6562-aa60-4d4d91c0681a" "published" ] |
16.87 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.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 "1f086777-3b89-6562-aa60-4d4d91c0681a" ] |
16.39 ms (0.51%) |
1 |
SELECT a0_.created_at AS created_at_0, a0_.updated_at AS updated_at_1, a0_.deleted_at AS deleted_at_2, a0_.uuid AS uuid_3, a0_.url_slug AS url_slug_4, a0_.og_description AS og_description_5, a0_.active AS active_6, a0_.id AS id_7, a0_.title AS title_8, a0_.content AS content_9, a0_.excerpt AS excerpt_10, a0_.published AS published_11, a0_.image_url AS image_url_12, a0_.meta_title AS meta_title_13, a0_.meta_description AS meta_description_14, a0_.meta_keywords AS meta_keywords_15, a0_.canonical_url AS canonical_url_16, a0_.robots AS robots_17, a0_.og_title AS og_title_18, a0_.og_image_path AS og_image_path_19, a0_.twitter_card_type AS twitter_card_type_20, a0_.extra_seo_data AS extra_seo_data_21, a0_.website_id AS website_id_22, a0_.author_id AS author_id_23 FROM article a0_ WHERE a0_.website_id = ? AND a0_.deleted_at IS NULL AND a0_.active = 1 AND (a0_.published IS NULL OR a0_.published = ?) LIMIT 10
Parameters:
[ "1f086777-3b89-6562-aa60-4d4d91c0681a" 1 ] |
16.33 ms (0.51%) |
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_ 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:
[ "1f086777-3b89-6562-aa60-4d4d91c0681a" "published" ] |
16.05 ms (0.50%) |
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"
]
|
15.99 ms (0.50%) |
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" ] |
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.