Query Metrics
72
Database Queries
7
Different statements
1346.16 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
565.47 ms (42.01%) |
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.website_id AS website_id_11 FROM `shop_setting` t0 WHERE t0.name = ? AND t0.website_id = ? LIMIT 1
Parameters:
[ "general_info_siteName" "1f086777-3b89-6562-aa60-4d4d91c0681a" ] |
422.37 ms (31.38%) |
27 |
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"
]
|
185.56 ms (13.78%) |
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"
]
|
62.50 ms (4.64%) |
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" ] |
47.25 ms (3.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.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"
]
|
31.54 ms (2.34%) |
2 |
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" ] |
31.46 ms (2.34%) |
2 |
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.