http://karen.poooshe.com/cart

Query Metrics

72 Database Queries
7 Different statements
1346.16 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.