Symfony Profiler

Query Metrics

48 Database Queries

18 Different statements

236.51 ms Query time

0 Invalid entities

147 Managed entities

Queries


SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.content AS content_4, t0.page_template AS page_template_5, t0.builder_sections AS builder_sections_6, t0.published_sections AS published_sections_7, t0.is_published AS is_published_8, t0.published_at AS published_at_9, t0.position AS position_10, t0.is_footer_menu AS is_footer_menu_11, t0.footer_placement AS footer_placement_12, t0.footer_position AS footer_position_13, t0.slider_enabled AS slider_enabled_14, t0.slider_type AS slider_type_15, t0.show_in_menu AS show_in_menu_16, t0.parent_id AS parent_id_17, t0.footer_parent_id AS footer_parent_id_18, t0.seo_meta_id AS seo_meta_id_19 FROM page t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.scope AS scope_6 FROM system_setting t0 WHERE t0.settings_key = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC
SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.available = ? AND ((p0_.is_active = ? OR p0_.is_active IS NULL))
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.label AS label_3, p0_.available AS available_4, p0_.slug AS slug_5, p0_.description AS description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.sku AS sku_9, p0_.short_description AS short_description_10, p0_.stock AS stock_11, p0_.delivery_time AS delivery_time_12, p0_.weight AS weight_13, p0_.length AS length_14, p0_.width AS width_15, p0_.height AS height_16, p0_.manufacturer AS manufacturer_17, p0_.ean AS ean_18, p0_.is_active AS is_active_19, p0_.special_price AS special_price_20, p0_.uvp AS uvp_21, p0_.tags AS tags_22, p0_.video_url AS video_url_23, p0_.material AS material_24, p0_.country_of_origin AS country_of_origin_25, p0_.custom1 AS custom1_26, p0_.custom2 AS custom2_27, p0_.mwst AS mwst_28, p0_.versandkosten AS versandkosten_29, p0_.pickup_available AS pickup_available_30, p0_.pickup_only AS pickup_only_31, p0_.pickup_note AS pickup_note_32, p0_.category_id AS category_id_33, p0_.seo_meta_id AS seo_meta_id_34, p0_.shipping_method_id AS shipping_method_id_35 FROM product p0_ WHERE p0_.available = ? AND ((p0_.is_active = ? OR p0_.is_active IS NULL)) LIMIT 12
SELECT t0.id AS id_1, t0.name AS name_2, t0.placeholder AS placeholder_3, t0.template_content AS template_content_4 FROM widget t0
SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ?
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id IS NULL ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? AND s0_.scope = ?
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = ? AND t0.status = ? LIMIT 1
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.configuration AS configuration_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6 FROM cart_item t0 WHERE t0.cart_id = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = ? AND t0.status = ? LIMIT 1
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? AND s0_.scope = ?
SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ?
SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?

#▲	Time	Info
1	0.55 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"shop_status"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'shop_status';
2	1.68 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"shop_product_limit"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'shop_product_limit';
3	2.26 ms	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.content AS content_4, t0.page_template AS page_template_5, t0.builder_sections AS builder_sections_6, t0.published_sections AS published_sections_7, t0.is_published AS is_published_8, t0.published_at AS published_at_9, t0.position AS position_10, t0.is_footer_menu AS is_footer_menu_11, t0.footer_placement AS footer_placement_12, t0.footer_position AS footer_position_13, t0.slider_enabled AS slider_enabled_14, t0.slider_type AS slider_type_15, t0.show_in_menu AS show_in_menu_16, t0.parent_id AS parent_id_17, t0.footer_parent_id AS footer_parent_id_18, t0.seo_meta_id AS seo_meta_id_19 FROM page t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"shop"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.content AS content_4, t0.page_template AS page_template_5, t0.builder_sections AS builder_sections_6, t0.published_sections AS published_sections_7, t0.is_published AS is_published_8, t0.published_at AS published_at_9, t0.position AS position_10, t0.is_footer_menu AS is_footer_menu_11, t0.footer_placement AS footer_placement_12, t0.footer_position AS footer_position_13, t0.slider_enabled AS slider_enabled_14, t0.slider_type AS slider_type_15, t0.show_in_menu AS show_in_menu_16, t0.parent_id AS parent_id_17, t0.footer_parent_id AS footer_parent_id_18, t0.seo_meta_id AS seo_meta_id_19 FROM page t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.content AS content_4, t0.page_template AS page_template_5, t0.builder_sections AS builder_sections_6, t0.published_sections AS published_sections_7, t0.is_published AS is_published_8, t0.published_at AS published_at_9, t0.position AS position_10, t0.is_footer_menu AS is_footer_menu_11, t0.footer_placement AS footer_placement_12, t0.footer_position AS footer_position_13, t0.slider_enabled AS slider_enabled_14, t0.slider_type AS slider_type_15, t0.show_in_menu AS show_in_menu_16, t0.parent_id AS parent_id_17, t0.footer_parent_id AS footer_parent_id_18, t0.seo_meta_id AS seo_meta_id_19 FROM page t0 WHERE t0.slug = 'shop' LIMIT 1;
4	2.57 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0;
5	1.66 ms	SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.scope AS scope_6 FROM system_setting t0 WHERE t0.settings_key = ? LIMIT 1 Parameters: [`"shop_menu_config"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.scope AS scope_6 FROM system_setting t0 WHERE t0.settings_key = ? LIMIT 1 SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.scope AS scope_6 FROM system_setting t0 WHERE t0.settings_key = 'shop_menu_config' LIMIT 1;
6	3.59 ms	SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC;
7	0.95 ms	SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC;
8	6.91 ms	SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC Parameters: [`"main"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = 'main' AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC;
9	6.92 ms	SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC Parameters: [`"legal"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = 'legal' AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC;
10	0.54 ms	SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.available = ? AND ((p0_.is_active = ? OR p0_.is_active IS NULL)) Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.available = ? AND ( ( p0_.is_active = ? OR p0_.is_active IS NULL ) ) SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.available = 1 AND ((p0_.is_active = 1 OR p0_.is_active IS NULL));
11	1.90 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.label AS label_3, p0_.available AS available_4, p0_.slug AS slug_5, p0_.description AS description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.sku AS sku_9, p0_.short_description AS short_description_10, p0_.stock AS stock_11, p0_.delivery_time AS delivery_time_12, p0_.weight AS weight_13, p0_.length AS length_14, p0_.width AS width_15, p0_.height AS height_16, p0_.manufacturer AS manufacturer_17, p0_.ean AS ean_18, p0_.is_active AS is_active_19, p0_.special_price AS special_price_20, p0_.uvp AS uvp_21, p0_.tags AS tags_22, p0_.video_url AS video_url_23, p0_.material AS material_24, p0_.country_of_origin AS country_of_origin_25, p0_.custom1 AS custom1_26, p0_.custom2 AS custom2_27, p0_.mwst AS mwst_28, p0_.versandkosten AS versandkosten_29, p0_.pickup_available AS pickup_available_30, p0_.pickup_only AS pickup_only_31, p0_.pickup_note AS pickup_note_32, p0_.category_id AS category_id_33, p0_.seo_meta_id AS seo_meta_id_34, p0_.shipping_method_id AS shipping_method_id_35 FROM product p0_ WHERE p0_.available = ? AND ((p0_.is_active = ? OR p0_.is_active IS NULL)) LIMIT 12 Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.label AS label_3, p0_.available AS available_4, p0_.slug AS slug_5, p0_.description AS description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.sku AS sku_9, p0_.short_description AS short_description_10, p0_.stock AS stock_11, p0_.delivery_time AS delivery_time_12, p0_.weight AS weight_13, p0_.length AS length_14, p0_.width AS width_15, p0_.height AS height_16, p0_.manufacturer AS manufacturer_17, p0_.ean AS ean_18, p0_.is_active AS is_active_19, p0_.special_price AS special_price_20, p0_.uvp AS uvp_21, p0_.tags AS tags_22, p0_.video_url AS video_url_23, p0_.material AS material_24, p0_.country_of_origin AS country_of_origin_25, p0_.custom1 AS custom1_26, p0_.custom2 AS custom2_27, p0_.mwst AS mwst_28, p0_.versandkosten AS versandkosten_29, p0_.pickup_available AS pickup_available_30, p0_.pickup_only AS pickup_only_31, p0_.pickup_note AS pickup_note_32, p0_.category_id AS category_id_33, p0_.seo_meta_id AS seo_meta_id_34, p0_.shipping_method_id AS shipping_method_id_35 FROM product p0_ WHERE p0_.available = ? AND ( ( p0_.is_active = ? OR p0_.is_active IS NULL ) ) LIMIT 12 SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.label AS label_3, p0_.available AS available_4, p0_.slug AS slug_5, p0_.description AS description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.sku AS sku_9, p0_.short_description AS short_description_10, p0_.stock AS stock_11, p0_.delivery_time AS delivery_time_12, p0_.weight AS weight_13, p0_.length AS length_14, p0_.width AS width_15, p0_.height AS height_16, p0_.manufacturer AS manufacturer_17, p0_.ean AS ean_18, p0_.is_active AS is_active_19, p0_.special_price AS special_price_20, p0_.uvp AS uvp_21, p0_.tags AS tags_22, p0_.video_url AS video_url_23, p0_.material AS material_24, p0_.country_of_origin AS country_of_origin_25, p0_.custom1 AS custom1_26, p0_.custom2 AS custom2_27, p0_.mwst AS mwst_28, p0_.versandkosten AS versandkosten_29, p0_.pickup_available AS pickup_available_30, p0_.pickup_only AS pickup_only_31, p0_.pickup_note AS pickup_note_32, p0_.category_id AS category_id_33, p0_.seo_meta_id AS seo_meta_id_34, p0_.shipping_method_id AS shipping_method_id_35 FROM product p0_ WHERE p0_.available = 1 AND ((p0_.is_active = 1 OR p0_.is_active IS NULL)) LIMIT 12;
12	7.27 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.placeholder AS placeholder_3, t0.template_content AS template_content_4 FROM widget t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.placeholder AS placeholder_3, t0.template_content AS template_content_4 FROM widget t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.placeholder AS placeholder_3, t0.template_content AS template_content_4 FROM widget t0;
13	70.80 ms	SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ? Parameters: [`"de" "messages"`] View formatted query View runnable query Explain query SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ? SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = 'de' AND t0_.domain = 'messages';
14	4.66 ms	SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`3509 3510 3511 3512 3513 3514 3515 3516 3517 3518 3519 3520`] View formatted query View runnable query Explain query SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3518, 3519, 3520);
15	8.81 ms	SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`3509 3510 3511 3512 3513 3514 3515 3516 3517 3518 3519 3520`] View formatted query View runnable query Explain query SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3518, 3519, 3520);
16	2.01 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id IS NULL ORDER BY t0.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id IS NULL ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id IS NULL ORDER BY t0.name ASC;
17	1.17 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC Parameters: [`891`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = 891 ORDER BY t0.name ASC;
18	2.07 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC Parameters: [`892`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = 892 ORDER BY t0.name ASC;
19	2.93 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC Parameters: [`893`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0 WHERE t0.parent_id = 893 ORDER BY t0.name ASC;
20	3.96 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"shop_currency"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'shop_currency';
21	6.17 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? AND s0_.scope = ? Parameters: [`"cart_session_lifetime" "frontend"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? AND s0_.scope = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'cart_session_lifetime' AND s0_.scope = 'frontend';
22	6.80 ms	SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = ? AND t0.status = ? LIMIT 1 Parameters: [`"" "open"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = ? AND t0.status = ? LIMIT 1 SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = '' AND t0.status = 'open' LIMIT 1;
23	7.08 ms	SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.configuration AS configuration_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6 FROM cart_item t0 WHERE t0.cart_id = ? Parameters: [`790`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.configuration AS configuration_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6 FROM cart_item t0 WHERE t0.cart_id = ? SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.configuration AS configuration_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6 FROM cart_item t0 WHERE t0.cart_id = 790;
24	3.75 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"sitename"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'sitename';
25	0.45 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"siteslogan"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'siteslogan';
26	0.35 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"shop_phone"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'shop_phone';
27	0.28 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"site_email"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'site_email';
28	3.91 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"site_opening_hours"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'site_opening_hours';
29	0.38 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"site_city"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'site_city';
30	0.71 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"site_top_location"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'site_top_location';
31	2.45 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"site_opening_hours_header"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'site_opening_hours_header';
32	0.31 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? Parameters: [`"shop_logo"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'shop_logo';
33	6.22 ms	SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = ? AND t0.status = ? LIMIT 1 Parameters: [`"u6658v4m6c4g1gtvmlupqk5dgl" "open"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = ? AND t0.status = ? LIMIT 1 SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = 'u6658v4m6c4g1gtvmlupqk5dgl' AND t0.status = 'open' LIMIT 1;
34	2.68 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3509`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3509;
35	5.99 ms	SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? AND s0_.scope = ? Parameters: [`"shop_product_fulfillment_badges_enabled" "frontend"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ? AND s0_.scope = ? SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = 'shop_product_fulfillment_badges_enabled' AND s0_.scope = 'frontend';
36	0.58 ms	SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ? Parameters: [`"de" "frontend_shop"`] View formatted query View runnable query Explain query SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ? SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = 'de' AND t0_.domain = 'frontend_shop';
37	5.62 ms	SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ? Parameters: [`"de" "frontend_configurator"`] View formatted query View runnable query Explain query SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ? SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = 'de' AND t0_.domain = 'frontend_configurator';
38	5.41 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3510`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3510;
39	0.37 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3511`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3511;
40	7.32 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3512`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3512;
41	3.91 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3513`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3513;
42	3.83 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3514`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3514;
43	5.47 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3515`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3515;
44	5.32 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3516`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3516;
45	2.30 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3517`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3517;
46	5.86 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3518`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3518;
47	5.70 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3519`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3519;
48	4.09 ms	SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? Parameters: [`3520`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 3520;

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\SeoMeta	51
App\Entity\Category	33
App\Entity\Widget	18
App\Entity\Product	12
App\Entity\ProductImage	12
App\Entity\SystemSetting	10
App\Entity\Page	10
App\Entity\Cart	1

Entities Mapping

Class	Mapping errors
App\Entity\SystemSetting	No errors.
App\Entity\Page	No errors.
App\Entity\SeoMeta	No errors.
App\Entity\Category	No errors.
App\Entity\Product	No errors.
App\Entity\ShippingMethod	No errors.
App\Entity\ProductImage	No errors.
App\Entity\Widget	No errors.
App\Entity\Translation	No errors.
App\Entity\ProductConfigurator	No errors.
App\Entity\ConfigurableProduct	No errors.
App\Entity\Cart	No errors.
App\Entity\Customer	No errors.
App\Entity\Coupon	No errors.
App\Entity\CartItem	No errors.

Symfony Profiler

GET https://www.nfok.work/shop?view=card

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping