Symfony Profiler

Query Metrics

239 Database Queries
24 Different statements
101.14 ms Query time
0 Invalid entities
152 Managed entities
Queries


SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = ? LIMIT 1
SELECT e0_.foreign_key AS foreign_key_0 FROM ext_translations e0_ WHERE e0_.locale = ? AND e0_.object_class = ? AND e0_.field = ? AND e0_.content = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.slug = ? LIMIT 1
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, p0_.slug) AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.slug_prefix AS slug_prefix_4, t0.controller_name AS controller_name_5 FROM category_type t0 WHERE t0.id = ?
SELECT e0_.foreign_key AS foreign_key_0 FROM ext_translations e0_ WHERE e0_.locale = ? AND e0_.object_class = ? AND e0_.field = ? AND e0_.content = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.additional_data AS additional_data_19, t0.special_category_code AS special_category_code_20, t0.category_type_id AS category_type_id_21, t0.upload_id AS upload_id_22 FROM p_category t0 WHERE t0.slug = ? LIMIT 1
SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, p0_.slug) AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.id = ?
SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = ? ORDER BY s0_.name ASC LIMIT 1
WITH RECURSIVE category_tree AS (
            -- Anchor member: start with the requested parent
            SELECT CAST(? AS UNSIGNED) AS id
            UNION ALL
            -- Recursive member: join the mapping table to the tree
            SELECT cc.category_sub_id
            FROM p_category_category cc
            INNER JOIN category_tree ct ON cc.category_super_id = ct.id
        )
        SELECT id FROM category_tree
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id WHERE (p0_.is_visible = ? AND c1_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.product_view_type_id IN (?)) AND (p0_.is_active = true)
WITH RECURSIVE category_tree AS (
            -- Anchor member: start with the requested parent
            SELECT CAST(? AS UNSIGNED) AS id
            UNION ALL
            -- Recursive member: join the mapping table to the tree
            SELECT cc.category_sub_id
            FROM p_category_category cc
            INNER JOIN category_tree ct ON cc.category_super_id = ct.id
        )
        SELECT id FROM category_tree
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id WHERE (p0_.is_visible = ? AND c1_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.product_view_type_id IN (?)) AND (p0_.is_active = true) ORDER BY c1_.sequence ASC, p0_.id DESC LIMIT 40
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.additional_data AS additional_data_18, t0.is_deleted AS is_deleted_19, t0.producer_id AS producer_id_20, t0.upload_id AS upload_id_21, t0.product_type_id AS product_type_id_22, t0.product_view_type_id AS product_view_type_id_23 FROM product t0 WHERE t0.id = ? AND ((t0.is_active = true))
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.class AS class_3, a0_.is_purchasable AS is_purchasable_4, a0_.sequence AS sequence_5 FROM availability a0_ LEFT JOIN product_variant p1_ ON a0_.id = p1_.availability_id AND (p1_.is_active = true) WHERE p1_.product_id = ? ORDER BY a0_.sequence ASC LIMIT 1
SELECT p0_.data AS data_0, p1_.name AS name_1 FROM parameter p0_ LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id AND (p2_.is_active = true) LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id WHERE p2_.product_id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.vat AS vat_2, p0_.minimal_amount AS minimal_amount_3, p0_.discount AS discount_4, p0_.valid_from AS valid_from_5, p0_.valid_until AS valid_until_6, p0_.created AS created_7, p0_.is_package AS is_package_8, p0_.min_price AS min_price_9, (p0_.price * (1 - p0_.discount) * (1 + p0_.vat)) AS sclr_10, p0_.product_variant_id AS product_variant_id_11, p0_.event_id AS event_id_12 FROM price p0_ INNER JOIN product_variant p1_ ON p0_.product_variant_id = p1_.id AND (p1_.is_active = true) WHERE p1_.product_id = ? AND p0_.valid_from <= ? AND ((p0_.valid_until IS NULL OR p0_.valid_until > ?)) ORDER BY p0_.minimal_amount ASC, sclr_10 ASC LIMIT 1
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.state AS state_3, t0.delivery_from AS delivery_from_4, t0.delivery_until AS delivery_until_5, t0.purchase_id AS purchase_id_6, t0.product_variant_id AS product_variant_id_7, t0.price_id AS price_id_8 FROM purchase_product_variant t0 WHERE t0.price_id = ?
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.valid_from AS valid_from_2, c0_.rate AS rate_3, c0_.currency_id AS currency_id_4 FROM conversion_rate c0_ WHERE c0_.currency_id = ? AND c0_.valid_from <= ? ORDER BY c0_.valid_from DESC LIMIT 1
WITH RECURSIVE category_tree AS (
            -- Anchor member: start with the requested parent
            SELECT CAST(? AS UNSIGNED) AS id
            UNION ALL
            -- Recursive member: join the mapping table to the tree
            SELECT cc.category_sub_id
            FROM p_category_category cc
            INNER JOIN category_tree ct ON cc.category_super_id = ct.id
        )
        SELECT id FROM category_tree
SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.title AS title_3, p0_.description AS description_4, p0_.html AS html_5, p0_.is_menu AS is_menu_6, p0_.slug AS slug_7, p0_.upload_id AS upload_id_8 FROM producer p0_ INNER JOIN product p1_ ON p0_.id = p1_.producer_id AND (p1_.is_active = true) INNER JOIN category_product c2_ ON p1_.id = c2_.product_id WHERE c2_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p1_.is_active = 1
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
WITH RECURSIVE category_tree AS (
            -- Anchor member: start with the requested parent
            SELECT CAST(? AS UNSIGNED) AS id
            UNION ALL
            -- Recursive member: join the mapping table to the tree
            SELECT cc.category_sub_id
            FROM p_category_category cc
            INNER JOIN category_tree ct ON cc.category_super_id = ct.id
        )
        SELECT id FROM category_tree
SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM product p1_ INNER JOIN category_product c2_ ON p1_.id = c2_.product_id INNER JOIN product_product p3_ ON p1_.id = p3_.parent_product_id INNER JOIN product_product_type p4_ ON p3_.product_product_type_id = p4_.id INNER JOIN product p0_ ON p3_.children_product_id = p0_.id AND (p0_.is_active = true) WHERE (c2_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p4_.name = ? AND p1_.is_visible = 1) AND (p1_.is_active = true) ORDER BY p0_.name ASC
SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.html) AS html_4, COALESCE(t5_.content, p0_.title) AS title_5, p0_.is_active AS is_active_6, COALESCE(t6_.content, p0_.slug) AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p7_ ON p0_.id = p7_.category_sub_id LEFT JOIN category_menu_type c8_ ON p0_.id = c8_.category_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'html' AND t4_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'title' AND t5_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'slug' AND t6_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category' AND t6_.foreign_key = p0_.id WHERE p0_.is_active = ? AND p0_.id >= ? AND p7_.id IS NULL AND c8_.menu_type_id = ? AND p0_.category_type_id IN (?) ORDER BY c8_.sequence ASC
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 ORDER BY p1_.sequence ASC, p0_.sequence ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC
SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = ?
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC
SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = ?
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.additional_data AS additional_data_18, p0_.special_category_code AS special_category_code_19, p0_.category_type_id AS category_type_id_20, p0_.upload_id AS upload_id_21 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = ? AND p0_.category_type_id = ? AND p0_.is_active = 1 AND p0_.id > 10 ORDER BY p1_.sequence ASC, p0_.sequence ASC
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.restriction AS restriction_14, t0.upload_group_id AS upload_group_id_15, t0.upload_type_id AS upload_type_id_16 FROM upload t0 WHERE t0.id = ?
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
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
Greendot\EshopBundle\Entity\Project\Upload	35
Greendot\EshopBundle\Entity\Project\UploadGroup	32
Greendot\EshopBundle\Entity\Project\Category	21
Greendot\EshopBundle\Entity\Project\Product	18
Greendot\EshopBundle\Entity\Project\Price	17
Greendot\EshopBundle\Entity\Project\ProductVariant	17
Greendot\EshopBundle\Entity\Project\CategoryType	4
Greendot\EshopBundle\Entity\Project\Availability	2
Greendot\EshopBundle\Entity\Project\CategoryCategory	2
Greendot\EshopBundle\Entity\Project\Currency	1
Greendot\EshopBundle\Entity\Project\ProductViewType	1
Greendot\EshopBundle\Entity\Project\ConversionRate	1
Greendot\EshopBundle\Entity\Project\Producer	1
Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Currency	No errors.
Greendot\EshopBundle\Entity\Project\ConversionRate	No errors.
Greendot\EshopBundle\Entity\Project\Category	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
Greendot\EshopBundle\Entity\Project\CategoryType	No errors.
Greendot\EshopBundle\Entity\Project\Upload	No errors.
Greendot\EshopBundle\Entity\Project\Label	No errors.
Greendot\EshopBundle\Entity\Project\CategoryFile	No errors.
Greendot\EshopBundle\Entity\Project\CategoryCategory	No errors.
Greendot\EshopBundle\Entity\Project\Parameter	No errors.
Greendot\EshopBundle\Entity\Project\CategoryProduct	No errors.
Greendot\EshopBundle\Entity\Project\Comment	No errors.
Greendot\EshopBundle\Entity\Project\CategoryPerson	No errors.
Greendot\EshopBundle\Entity\Project\CategoryEvent	No errors.
Greendot\EshopBundle\Entity\Project\CategoryUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\CategoryMenuType	No errors.
Greendot\EshopBundle\Entity\Project\SubMenuType	No errors.
Greendot\EshopBundle\Entity\Project\CategoryParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\Settings	No errors.
Greendot\EshopBundle\Entity\Project\Product	No errors.
Greendot\EshopBundle\Entity\Project\Producer	No errors.
Greendot\EshopBundle\Entity\Project\ProductType	No errors.
Greendot\EshopBundle\Entity\Project\ProductViewType	No errors.
Greendot\EshopBundle\Entity\Project\ProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Review	No errors.
Greendot\EshopBundle\Entity\Project\ProductUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductPerson	No errors.
Greendot\EshopBundle\Entity\Project\ProductParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductProduct	No errors.
Greendot\EshopBundle\Entity\Project\ProductInformationBlock	No errors.
Greendot\EshopBundle\Entity\Project\Availability	No errors.
Greendot\EshopBundle\Entity\Project\ParameterGroup	No errors.
Greendot\EshopBundle\Entity\Project\Price	No errors.
Greendot\EshopBundle\Entity\Project\Event	No errors.
Greendot\EshopBundle\Entity\Project\PurchaseProductVariant	No errors.
Greendot\EshopBundle\Entity\Project\Purchase	No errors.
Greendot\EshopBundle\Entity\Project\ProducerUploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\ProductProductType	No errors.
Greendot\EshopBundle\Entity\Project\UploadGroup	No errors.
Greendot\EshopBundle\Entity\Project\UploadType	No errors.
Greendot\EshopBundle\Entity\Project\Person	No errors.
Greendot\EshopBundle\Entity\Project\InformationBlock	No errors.
Symfony Profiler

GET https://proklima.greendot.cz/en/dily-pro-vnitrni-rolety

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
