Symfony Profiler

Query Metrics

71 Database Queries
34 Different statements
29.49 ms Query time
0 Invalid entities
56 Managed entities
Queries


SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.host AS host_2, d0_.theme_name AS theme_name_3, d0_.locale AS locale_4, d0_.currency AS currency_5, d0_.active AS active_6, d0_.is_default AS is_default_7, d0_.created_at AS created_at_8, d0_.updated_at AS updated_at_9, d0_.eshop_id AS eshop_id_10, d0_.default_currency_id AS default_currency_id_11, d0_.default_country_id AS default_country_id_12 FROM domain d0_ WHERE d0_.host = ? AND d0_.active = ?
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.host AS host_2, d0_.theme_name AS theme_name_3, d0_.locale AS locale_4, d0_.currency AS currency_5, d0_.active AS active_6, d0_.is_default AS is_default_7, d0_.created_at AS created_at_8, d0_.updated_at AS updated_at_9, d0_.eshop_id AS eshop_id_10, d0_.default_currency_id AS default_currency_id_11, d0_.default_country_id AS default_country_id_12 FROM domain d0_ WHERE d0_.is_default = ? AND d0_.active = ?
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.type AS type_2, p0_.model_id AS model_id_3, p0_.default_item_id AS default_item_id_4, p0_.position AS position_5, p0_.is_active AS is_active_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.product_id LEFT JOIN product_domain p2_ ON p0_.id = p2_.product_id WHERE (p1_.slug = ? OR p0_.code = ?) AND (p2_.domain_id = ? AND p2_.is_active = 1) LIMIT 1
SELECT t0.id AS id_1, t0.role AS role_2, t0.is_default AS is_default_3, t0.position AS position_4, t0.product_id AS product_id_5, t0.item_id AS item_id_6 FROM product_item t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.model_id AS model_id_4, t0.default_item_id AS default_item_id_5, t0.position AS position_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM product t0 INNER JOIN product_related ON t0.id = product_related.related_product_id WHERE product_related.product_id = ?
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_5 FROM (SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.type AS type_2, p0_.model_id AS model_id_3, p0_.default_item_id AS default_item_id_4, p0_.position AS position_5, p0_.is_active AS is_active_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p1_.id AS id_9, p1_.locale AS locale_10, p1_.name AS name_11, p1_.slug AS slug_12, p1_.short_description AS short_description_13, p1_.description AS description_14, p1_.meta_title AS meta_title_15, p1_.meta_description AS meta_description_16, p1_.meta_keywords AS meta_keywords_17, p1_.feed_name AS feed_name_18, p1_.feed_description AS feed_description_19, p1_.feed_labels AS feed_labels_20, p1_.feed_zbozi_description AS feed_zbozi_description_21, p1_.feed_heureka_description AS feed_heureka_description_22, p1_.option_name AS option_name_23, p1_.option_cart_name AS option_cart_name_24, p1_.option_description AS option_description_25, p2_.id AS id_26, p2_.type AS type_27, p2_.role AS role_28, p2_.filename AS filename_29, p2_.external_url AS external_url_30, p2_.thumbnail AS thumbnail_31, p2_.layer_key AS layer_key_32, p2_.inherits_mattress_overlay AS inherits_mattress_overlay_33, p2_.is_main AS is_main_34, p2_.position AS position_35, p2_.created_at AS created_at_36, p3_.id AS id_37, p3_.url AS url_38, p3_.is_active AS is_active_39 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.product_id LEFT JOIN product_media p2_ ON p0_.id = p2_.product_id INNER JOIN product_domain p3_ ON p0_.id = p3_.product_id WHERE p0_.is_active = 1 AND p3_.domain_id = ? AND p3_.is_active = 1 ORDER BY p2_.position ASC) dctrn_result_inner ORDER BY position_5 ASC, id_0 DESC) dctrn_result LIMIT 4
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.type AS type_2, p0_.model_id AS model_id_3, p0_.default_item_id AS default_item_id_4, p0_.position AS position_5, p0_.is_active AS is_active_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p1_.id AS id_9, p1_.locale AS locale_10, p1_.name AS name_11, p1_.slug AS slug_12, p1_.short_description AS short_description_13, p1_.description AS description_14, p1_.meta_title AS meta_title_15, p1_.meta_description AS meta_description_16, p1_.meta_keywords AS meta_keywords_17, p1_.feed_name AS feed_name_18, p1_.feed_description AS feed_description_19, p1_.feed_labels AS feed_labels_20, p1_.feed_zbozi_description AS feed_zbozi_description_21, p1_.feed_heureka_description AS feed_heureka_description_22, p1_.option_name AS option_name_23, p1_.option_cart_name AS option_cart_name_24, p1_.option_description AS option_description_25, p2_.id AS id_26, p2_.type AS type_27, p2_.role AS role_28, p2_.filename AS filename_29, p2_.external_url AS external_url_30, p2_.thumbnail AS thumbnail_31, p2_.layer_key AS layer_key_32, p2_.inherits_mattress_overlay AS inherits_mattress_overlay_33, p2_.is_main AS is_main_34, p2_.position AS position_35, p2_.created_at AS created_at_36, p3_.id AS id_37, p3_.url AS url_38, p3_.is_active AS is_active_39, p1_.product_id AS product_id_40, p2_.product_id AS product_id_41, p2_.domain_id AS domain_id_42, p2_.layer_item_id AS layer_item_id_43, p2_.layer_color_id AS layer_color_id_44, p3_.product_id AS product_id_45, p3_.domain_id AS domain_id_46, p3_.default_category_id AS default_category_id_47 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.id = p1_.product_id LEFT JOIN product_media p2_ ON p0_.id = p2_.product_id INNER JOIN product_domain p3_ ON p0_.id = p3_.product_id WHERE p0_.is_active = 1 AND p3_.domain_id = ? AND p3_.is_active = 1 AND p0_.id IN (?, ?, ?, ?) ORDER BY p0_.position ASC, p0_.id DESC, p2_.position ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.kind AS kind_3, t0.model_id AS model_id_4, t0.packaging AS packaging_5, t0.name AS name_6, t0.width_cm AS width_cm_7, t0.length_cm AS length_cm_8, t0.height_cm AS height_cm_9, t0.weight_kg AS weight_kg_10, t0.manufacturer_id AS manufacturer_id_11, t0.supplier_id AS supplier_id_12, t0.purchase_price AS purchase_price_13, t0.purchase_currency AS purchase_currency_14, t0.shipping_coefficient AS shipping_coefficient_15, t0.purchase_price_shipped AS purchase_price_shipped_16, t0.production_cost_czk AS production_cost_czk_17, t0.production_cost_eur AS production_cost_eur_18, t0.production_cost_list AS production_cost_list_19, t0.ft AS ft_20, t0.work_rate AS work_rate_21, t0.work_hours AS work_hours_22, t0.min_stock AS min_stock_23, t0.has_parts_in_list AS has_parts_in_list_24, t0.competitor_prices AS competitor_prices_25, t0.exceptions AS exceptions_26, t0.source AS source_27, t0.note AS note_28, t0.carrier AS carrier_29, t0.group_name AS group_name_30, t0.is_sold_separately AS is_sold_separately_31, t0.manual_url AS manual_url_32, t0.image_url AS image_url_33, t0.pohoda_stock AS pohoda_stock_34, t0.pohoda_reserved AS pohoda_reserved_35, t0.stock AS stock_36, t0.reserved AS reserved_37, t0.position AS position_38, t0.is_active AS is_active_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41 FROM item t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.original_price AS original_price_3, t0.new_price AS new_price_4, t0.price_coefficient AS price_coefficient_5, t0.repriced_at AS repriced_at_6, t0.text_in_stock AS text_in_stock_7, t0.text_out_of_stock AS text_out_of_stock_8, t0.item_id AS item_id_9, t0.domain_id AS domain_id_10 FROM item_domain t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.symbol AS symbol_4, t0.exchange_rate AS exchange_rate_5, t0.symbol_position AS symbol_position_6, t0.decimal_places AS decimal_places_7, t0.is_default AS is_default_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM currency t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.type AS type_4, t0.is_required AS is_required_5, t0.position AS position_6, t0.product_id AS product_id_7 FROM config_group t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.role AS role_2, t0.is_default AS is_default_3, t0.position AS position_4, t0.product_id AS product_id_5, t0.item_id AS item_id_6 FROM product_item t0 WHERE t0.item_id = ? AND t0.role = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.type AS type_3, c0_.is_required AS is_required_4, c0_.position AS position_5, c1_.id AS id_6, c1_.locale AS locale_7, c1_.name AS name_8, c2_.id AS id_9, c2_.code AS code_10, c2_.is_default AS is_default_11, c2_.is_included AS is_included_12, c2_.position AS position_13, i3_.id AS id_14, i3_.code AS code_15, i3_.kind AS kind_16, i3_.model_id AS model_id_17, i3_.packaging AS packaging_18, i3_.name AS name_19, i3_.width_cm AS width_cm_20, i3_.length_cm AS length_cm_21, i3_.height_cm AS height_cm_22, i3_.weight_kg AS weight_kg_23, i3_.manufacturer_id AS manufacturer_id_24, i3_.supplier_id AS supplier_id_25, i3_.purchase_price AS purchase_price_26, i3_.purchase_currency AS purchase_currency_27, i3_.shipping_coefficient AS shipping_coefficient_28, i3_.purchase_price_shipped AS purchase_price_shipped_29, i3_.production_cost_czk AS production_cost_czk_30, i3_.production_cost_eur AS production_cost_eur_31, i3_.production_cost_list AS production_cost_list_32, i3_.ft AS ft_33, i3_.work_rate AS work_rate_34, i3_.work_hours AS work_hours_35, i3_.min_stock AS min_stock_36, i3_.has_parts_in_list AS has_parts_in_list_37, i3_.competitor_prices AS competitor_prices_38, i3_.exceptions AS exceptions_39, i3_.source AS source_40, i3_.note AS note_41, i3_.carrier AS carrier_42, i3_.group_name AS group_name_43, i3_.is_sold_separately AS is_sold_separately_44, i3_.manual_url AS manual_url_45, i3_.image_url AS image_url_46, i3_.pohoda_stock AS pohoda_stock_47, i3_.pohoda_reserved AS pohoda_reserved_48, i3_.stock AS stock_49, i3_.reserved AS reserved_50, i3_.position AS position_51, i3_.is_active AS is_active_52, i3_.created_at AS created_at_53, i3_.updated_at AS updated_at_54, c4_.id AS id_55, c4_.code AS code_56, c4_.color_group AS color_group_57, c4_.hex AS hex_58, c4_.image_url AS image_url_59, c4_.position AS position_60, c4_.is_active AS is_active_61, c5_.position AS position_62, c6_.id AS id_63, c6_.code AS code_64, c6_.color_group AS color_group_65, c6_.hex AS hex_66, c6_.image_url AS image_url_67, c6_.position AS position_68, c6_.is_active AS is_active_69, c7_.id AS id_70, c7_.bundle_code AS bundle_code_71, c7_.quantity AS quantity_72, i8_.id AS id_73, i8_.code AS code_74, i8_.kind AS kind_75, i8_.model_id AS model_id_76, i8_.packaging AS packaging_77, i8_.name AS name_78, i8_.width_cm AS width_cm_79, i8_.length_cm AS length_cm_80, i8_.height_cm AS height_cm_81, i8_.weight_kg AS weight_kg_82, i8_.manufacturer_id AS manufacturer_id_83, i8_.supplier_id AS supplier_id_84, i8_.purchase_price AS purchase_price_85, i8_.purchase_currency AS purchase_currency_86, i8_.shipping_coefficient AS shipping_coefficient_87, i8_.purchase_price_shipped AS purchase_price_shipped_88, i8_.production_cost_czk AS production_cost_czk_89, i8_.production_cost_eur AS production_cost_eur_90, i8_.production_cost_list AS production_cost_list_91, i8_.ft AS ft_92, i8_.work_rate AS work_rate_93, i8_.work_hours AS work_hours_94, i8_.min_stock AS min_stock_95, i8_.has_parts_in_list AS has_parts_in_list_96, i8_.competitor_prices AS competitor_prices_97, i8_.exceptions AS exceptions_98, i8_.source AS source_99, i8_.note AS note_100, i8_.carrier AS carrier_101, i8_.group_name AS group_name_102, i8_.is_sold_separately AS is_sold_separately_103, i8_.manual_url AS manual_url_104, i8_.image_url AS image_url_105, i8_.pohoda_stock AS pohoda_stock_106, i8_.pohoda_reserved AS pohoda_reserved_107, i8_.stock AS stock_108, i8_.reserved AS reserved_109, i8_.position AS position_110, i8_.is_active AS is_active_111, i8_.created_at AS created_at_112, i8_.updated_at AS updated_at_113, c9_.id AS id_114, c9_.group_code AS group_code_115, c9_.group_name AS group_name_116, c9_.code AS code_117, c9_.name AS name_118, c9_.position AS position_119, c0_.product_id AS product_id_120, c1_.config_group_id AS config_group_id_121, c2_.config_group_id AS config_group_id_122, c2_.item_id AS item_id_123, c2_.color_id AS color_id_124, c5_.config_option_id AS config_option_id_125, c5_.color_id AS color_id_126, c7_.config_option_id AS config_option_id_127, c7_.item_id AS item_id_128, c10_.config_option_id AS config_option_id_129, c10_.config_tag_id AS config_tag_id_130, c9_.product_id AS product_id_131 FROM config_group c0_ LEFT JOIN config_group_translation c1_ ON c0_.id = c1_.config_group_id LEFT JOIN config_option c2_ ON c0_.id = c2_.config_group_id LEFT JOIN item i3_ ON c2_.item_id = i3_.id LEFT JOIN color c4_ ON c2_.color_id = c4_.id LEFT JOIN config_option_color c5_ ON c2_.id = c5_.config_option_id LEFT JOIN color c6_ ON c5_.color_id = c6_.id LEFT JOIN config_option_bundle c7_ ON c2_.id = c7_.config_option_id LEFT JOIN item i8_ ON c7_.item_id = i8_.id LEFT JOIN config_option_tag c10_ ON c2_.id = c10_.config_option_id LEFT JOIN config_tag c9_ ON c10_.config_tag_id = c9_.id WHERE c0_.product_id = ? ORDER BY c0_.position ASC, c2_.position ASC, c5_.position ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.setting_key AS setting_key_2, s0_.setting_value AS setting_value_3, s0_.type AS type_4, s0_.group_name AS group_name_5, s0_.description AS description_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.domain_id AS domain_id_9 FROM shop_settings s0_ WHERE s0_.setting_key = ? AND s0_.domain_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.setting_key AS setting_key_2, s0_.setting_value AS setting_value_3, s0_.type AS type_4, s0_.group_name AS group_name_5, s0_.description AS description_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.domain_id AS domain_id_9 FROM shop_settings s0_ WHERE s0_.setting_key = ? AND s0_.domain_id IS NULL
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.slug AS slug_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.feed_name AS feed_name_10, t0.feed_description AS feed_description_11, t0.feed_labels AS feed_labels_12, t0.feed_zbozi_description AS feed_zbozi_description_13, t0.feed_heureka_description AS feed_heureka_description_14, t0.option_name AS option_name_15, t0.option_cart_name AS option_cart_name_16, t0.option_description AS option_description_17, t0.product_id AS product_id_18 FROM product_translation t0 WHERE t0.product_id = ?
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.placement AS placement_2, b0_.sklad_karta_kod AS sklad_karta_kod_3, b0_.sklad_model_kod AS sklad_model_kod_4, b0_.grid_position AS grid_position_5, b0_.position AS position_6, b0_.title AS title_7, b0_.subtitle AS subtitle_8, b0_.badge_text AS badge_text_9, b0_.button_text AS button_text_10, b0_.link_url AS link_url_11, b0_.target_blank AS target_blank_12, b0_.image AS image_13, b0_.background_color AS background_color_14, b0_.text_color AS text_color_15, b0_.valid_from AS valid_from_16, b0_.valid_to AS valid_to_17, b0_.is_active AS is_active_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.domain_id AS domain_id_21, b0_.category_id AS category_id_22, b0_.product_id AS product_id_23 FROM banners b0_ WHERE b0_.placement = ? AND b0_.is_active = 1 AND ((b0_.valid_from IS NULL OR b0_.valid_from <= ?)) AND ((b0_.valid_to IS NULL OR b0_.valid_to >= ?)) AND ((b0_.domain_id = ? OR b0_.domain_id IS NULL)) ORDER BY b0_.position ASC, b0_.id ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.image AS image_4, c0_.is_active AS is_active_5, c0_.position AS position_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.locale AS locale_10, c1_.name AS name_11, c1_.slug AS slug_12, c1_.description AS description_13, c0_.eshop_id AS eshop_id_14, c0_.parent_id AS parent_id_15, c1_.category_id AS category_id_16 FROM categories c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id WHERE c0_.eshop_id = ? AND c0_.parent_id IS NULL AND c0_.is_active = 1 ORDER BY c0_.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.eshop_id AS eshop_id_10, t0.parent_id AS parent_id_11 FROM categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.category_id AS category_id_6 FROM category_translation t0 WHERE t0.category_id = ?
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.eshop_id AS eshop_id_10, t0.parent_id AS parent_id_11 FROM categories t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.placement AS placement_2, b0_.sklad_karta_kod AS sklad_karta_kod_3, b0_.sklad_model_kod AS sklad_model_kod_4, b0_.grid_position AS grid_position_5, b0_.position AS position_6, b0_.title AS title_7, b0_.subtitle AS subtitle_8, b0_.badge_text AS badge_text_9, b0_.button_text AS button_text_10, b0_.link_url AS link_url_11, b0_.target_blank AS target_blank_12, b0_.image AS image_13, b0_.background_color AS background_color_14, b0_.text_color AS text_color_15, b0_.valid_from AS valid_from_16, b0_.valid_to AS valid_to_17, b0_.is_active AS is_active_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.domain_id AS domain_id_21, b0_.category_id AS category_id_22, b0_.product_id AS product_id_23 FROM banners b0_ WHERE b0_.placement = ? AND b0_.is_active = 1 AND ((b0_.valid_from IS NULL OR b0_.valid_from <= ?)) AND ((b0_.valid_to IS NULL OR b0_.valid_to >= ?)) AND ((b0_.domain_id = ? OR b0_.domain_id IS NULL)) AND ((b0_.product_id = ? OR b0_.product_id IS NULL)) ORDER BY b0_.position ASC, b0_.id ASC
SELECT t0.id AS id_1, t0.type AS type_2, t0.role AS role_3, t0.filename AS filename_4, t0.external_url AS external_url_5, t0.thumbnail AS thumbnail_6, t0.layer_key AS layer_key_7, t0.inherits_mattress_overlay AS inherits_mattress_overlay_8, t0.is_main AS is_main_9, t0.position AS position_10, t0.created_at AS created_at_11, t0.product_id AS product_id_12, t0.domain_id AS domain_id_13, t0.layer_item_id AS layer_item_id_14, t0.layer_color_id AS layer_color_id_15 FROM product_media t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.placement AS placement_2, b0_.sklad_karta_kod AS sklad_karta_kod_3, b0_.sklad_model_kod AS sklad_model_kod_4, b0_.grid_position AS grid_position_5, b0_.position AS position_6, b0_.title AS title_7, b0_.subtitle AS subtitle_8, b0_.badge_text AS badge_text_9, b0_.button_text AS button_text_10, b0_.link_url AS link_url_11, b0_.target_blank AS target_blank_12, b0_.image AS image_13, b0_.background_color AS background_color_14, b0_.text_color AS text_color_15, b0_.valid_from AS valid_from_16, b0_.valid_to AS valid_to_17, b0_.is_active AS is_active_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.domain_id AS domain_id_21, b0_.category_id AS category_id_22, b0_.product_id AS product_id_23 FROM banners b0_ WHERE b0_.placement = ? AND b0_.is_active = 1 AND ((b0_.valid_from IS NULL OR b0_.valid_from <= ?)) AND ((b0_.valid_to IS NULL OR b0_.valid_to >= ?)) AND ((b0_.domain_id = ? OR b0_.domain_id IS NULL)) AND ((b0_.product_id = ? OR b0_.product_id IS NULL)) ORDER BY b0_.position ASC, b0_.id ASC
SELECT t0.id AS id_1, t0.role AS role_2, t0.is_default AS is_default_3, t0.position AS position_4, t0.product_id AS product_id_5, t0.item_id AS item_id_6 FROM product_item t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.kind AS kind_3, t0.model_id AS model_id_4, t0.packaging AS packaging_5, t0.name AS name_6, t0.width_cm AS width_cm_7, t0.length_cm AS length_cm_8, t0.height_cm AS height_cm_9, t0.weight_kg AS weight_kg_10, t0.manufacturer_id AS manufacturer_id_11, t0.supplier_id AS supplier_id_12, t0.purchase_price AS purchase_price_13, t0.purchase_currency AS purchase_currency_14, t0.shipping_coefficient AS shipping_coefficient_15, t0.purchase_price_shipped AS purchase_price_shipped_16, t0.production_cost_czk AS production_cost_czk_17, t0.production_cost_eur AS production_cost_eur_18, t0.production_cost_list AS production_cost_list_19, t0.ft AS ft_20, t0.work_rate AS work_rate_21, t0.work_hours AS work_hours_22, t0.min_stock AS min_stock_23, t0.has_parts_in_list AS has_parts_in_list_24, t0.competitor_prices AS competitor_prices_25, t0.exceptions AS exceptions_26, t0.source AS source_27, t0.note AS note_28, t0.carrier AS carrier_29, t0.group_name AS group_name_30, t0.is_sold_separately AS is_sold_separately_31, t0.manual_url AS manual_url_32, t0.image_url AS image_url_33, t0.pohoda_stock AS pohoda_stock_34, t0.pohoda_reserved AS pohoda_reserved_35, t0.stock AS stock_36, t0.reserved AS reserved_37, t0.position AS position_38, t0.is_active AS is_active_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41 FROM item t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.original_price AS original_price_3, t0.new_price AS new_price_4, t0.price_coefficient AS price_coefficient_5, t0.repriced_at AS repriced_at_6, t0.text_in_stock AS text_in_stock_7, t0.text_out_of_stock AS text_out_of_stock_8, t0.item_id AS item_id_9, t0.domain_id AS domain_id_10 FROM item_domain t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.role AS role_2, t0.is_default AS is_default_3, t0.position AS position_4, t0.product_id AS product_id_5, t0.item_id AS item_id_6 FROM product_item t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.kind AS kind_3, t0.model_id AS model_id_4, t0.packaging AS packaging_5, t0.name AS name_6, t0.width_cm AS width_cm_7, t0.length_cm AS length_cm_8, t0.height_cm AS height_cm_9, t0.weight_kg AS weight_kg_10, t0.manufacturer_id AS manufacturer_id_11, t0.supplier_id AS supplier_id_12, t0.purchase_price AS purchase_price_13, t0.purchase_currency AS purchase_currency_14, t0.shipping_coefficient AS shipping_coefficient_15, t0.purchase_price_shipped AS purchase_price_shipped_16, t0.production_cost_czk AS production_cost_czk_17, t0.production_cost_eur AS production_cost_eur_18, t0.production_cost_list AS production_cost_list_19, t0.ft AS ft_20, t0.work_rate AS work_rate_21, t0.work_hours AS work_hours_22, t0.min_stock AS min_stock_23, t0.has_parts_in_list AS has_parts_in_list_24, t0.competitor_prices AS competitor_prices_25, t0.exceptions AS exceptions_26, t0.source AS source_27, t0.note AS note_28, t0.carrier AS carrier_29, t0.group_name AS group_name_30, t0.is_sold_separately AS is_sold_separately_31, t0.manual_url AS manual_url_32, t0.image_url AS image_url_33, t0.pohoda_stock AS pohoda_stock_34, t0.pohoda_reserved AS pohoda_reserved_35, t0.stock AS stock_36, t0.reserved AS reserved_37, t0.position AS position_38, t0.is_active AS is_active_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41 FROM item t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.original_price AS original_price_3, t0.new_price AS new_price_4, t0.price_coefficient AS price_coefficient_5, t0.repriced_at AS repriced_at_6, t0.text_in_stock AS text_in_stock_7, t0.text_out_of_stock AS text_out_of_stock_8, t0.item_id AS item_id_9, t0.domain_id AS domain_id_10 FROM item_domain t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.role AS role_2, t0.is_default AS is_default_3, t0.position AS position_4, t0.product_id AS product_id_5, t0.item_id AS item_id_6 FROM product_item t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.kind AS kind_3, t0.model_id AS model_id_4, t0.packaging AS packaging_5, t0.name AS name_6, t0.width_cm AS width_cm_7, t0.length_cm AS length_cm_8, t0.height_cm AS height_cm_9, t0.weight_kg AS weight_kg_10, t0.manufacturer_id AS manufacturer_id_11, t0.supplier_id AS supplier_id_12, t0.purchase_price AS purchase_price_13, t0.purchase_currency AS purchase_currency_14, t0.shipping_coefficient AS shipping_coefficient_15, t0.purchase_price_shipped AS purchase_price_shipped_16, t0.production_cost_czk AS production_cost_czk_17, t0.production_cost_eur AS production_cost_eur_18, t0.production_cost_list AS production_cost_list_19, t0.ft AS ft_20, t0.work_rate AS work_rate_21, t0.work_hours AS work_hours_22, t0.min_stock AS min_stock_23, t0.has_parts_in_list AS has_parts_in_list_24, t0.competitor_prices AS competitor_prices_25, t0.exceptions AS exceptions_26, t0.source AS source_27, t0.note AS note_28, t0.carrier AS carrier_29, t0.group_name AS group_name_30, t0.is_sold_separately AS is_sold_separately_31, t0.manual_url AS manual_url_32, t0.image_url AS image_url_33, t0.pohoda_stock AS pohoda_stock_34, t0.pohoda_reserved AS pohoda_reserved_35, t0.stock AS stock_36, t0.reserved AS reserved_37, t0.position AS position_38, t0.is_active AS is_active_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41 FROM item t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.original_price AS original_price_3, t0.new_price AS new_price_4, t0.price_coefficient AS price_coefficient_5, t0.repriced_at AS repriced_at_6, t0.text_in_stock AS text_in_stock_7, t0.text_out_of_stock AS text_out_of_stock_8, t0.item_id AS item_id_9, t0.domain_id AS domain_id_10 FROM item_domain t0 WHERE t0.item_id = ?
SELECT t0.id AS id_1, t0.role AS role_2, t0.is_default AS is_default_3, t0.position AS position_4, t0.product_id AS product_id_5, t0.item_id AS item_id_6 FROM product_item t0 WHERE t0.product_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.code AS code_2, t0.kind AS kind_3, t0.model_id AS model_id_4, t0.packaging AS packaging_5, t0.name AS name_6, t0.width_cm AS width_cm_7, t0.length_cm AS length_cm_8, t0.height_cm AS height_cm_9, t0.weight_kg AS weight_kg_10, t0.manufacturer_id AS manufacturer_id_11, t0.supplier_id AS supplier_id_12, t0.purchase_price AS purchase_price_13, t0.purchase_currency AS purchase_currency_14, t0.shipping_coefficient AS shipping_coefficient_15, t0.purchase_price_shipped AS purchase_price_shipped_16, t0.production_cost_czk AS production_cost_czk_17, t0.production_cost_eur AS production_cost_eur_18, t0.production_cost_list AS production_cost_list_19, t0.ft AS ft_20, t0.work_rate AS work_rate_21, t0.work_hours AS work_hours_22, t0.min_stock AS min_stock_23, t0.has_parts_in_list AS has_parts_in_list_24, t0.competitor_prices AS competitor_prices_25, t0.exceptions AS exceptions_26, t0.source AS source_27, t0.note AS note_28, t0.carrier AS carrier_29, t0.group_name AS group_name_30, t0.is_sold_separately AS is_sold_separately_31, t0.manual_url AS manual_url_32, t0.image_url AS image_url_33, t0.pohoda_stock AS pohoda_stock_34, t0.pohoda_reserved AS pohoda_reserved_35, t0.stock AS stock_36, t0.reserved AS reserved_37, t0.position AS position_38, t0.is_active AS is_active_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41 FROM item t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.original_price AS original_price_3, t0.new_price AS new_price_4, t0.price_coefficient AS price_coefficient_5, t0.repriced_at AS repriced_at_6, t0.text_in_stock AS text_in_stock_7, t0.text_out_of_stock AS text_out_of_stock_8, t0.item_id AS item_id_9, t0.domain_id AS domain_id_10 FROM item_domain t0 WHERE t0.item_id = ?
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.icon AS icon_3, s0_.link_url AS link_url_4, s0_.position AS position_5, s0_.is_active AS is_active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.domain_id AS domain_id_9 FROM shop_benefits s0_ WHERE s0_.is_active = 1 AND (s0_.domain_id = ? OR s0_.domain_id IS NULL) ORDER BY s0_.position ASC, s0_.id ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND c0_.locale = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ INNER JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id INNER JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ LEFT JOIN cubestudio_menu_domains c2_ ON c0_.id = c2_.menu_id LEFT JOIN domain d1_ ON d1_.id = c2_.domain_id WHERE c0_.menu_key = ? AND c0_.is_active = 1 AND d1_.id IS NULL LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.menu_key AS menu_key_2, c0_.locale AS locale_3, c0_.is_active AS is_active_4 FROM cubestudio_menu c0_ WHERE c0_.menu_key = ? AND c0_.is_active = 1 LIMIT 1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.banner_title AS banner_title_3, t0.banner_description AS banner_description_4, t0.accept_all_label AS accept_all_label_5, t0.reject_all_label AS reject_all_label_6, t0.settings_label AS settings_label_7, t0.save_label AS save_label_8, t0.privacy_policy_url AS privacy_policy_url_9, t0.privacy_policy_label AS privacy_policy_label_10, t0.position AS position_11, t0.policy_version AS policy_version_12, t0.is_enabled AS is_enabled_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM cubestudio_cookie_config t0 WHERE t0.locale = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.banner_title AS banner_title_2, c0_.banner_description AS banner_description_3, c0_.accept_all_label AS accept_all_label_4, c0_.reject_all_label AS reject_all_label_5, c0_.settings_label AS settings_label_6, c0_.save_label AS save_label_7, c0_.privacy_policy_url AS privacy_policy_url_8, c0_.privacy_policy_label AS privacy_policy_label_9, c0_.position AS position_10, c0_.policy_version AS policy_version_11, c0_.is_enabled AS is_enabled_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14 FROM cubestudio_cookie_config c0_ ORDER BY c0_.id ASC LIMIT 1
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.code AS code_2, c0_.name AS name_3, c0_.description AS description_4, c0_.is_required AS is_required_5, c0_.is_enabled_by_default AS is_enabled_by_default_6, c0_.sort_order AS sort_order_7, c0_.is_active AS is_active_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c1_.id AS id_11, c1_.name AS name_12, c1_.provider AS provider_13, c1_.purpose AS purpose_14, c1_.expiration AS expiration_15, c1_.is_active AS is_active_16, c1_.sort_order AS sort_order_17, c1_.created_at AS created_at_18, c1_.updated_at AS updated_at_19, c1_.category_id AS category_id_20 FROM cubestudio_cookie_category c0_ LEFT JOIN cubestudio_cookie_item c1_ ON c0_.id = c1_.category_id WHERE c0_.is_active = ? AND c0_.locale = ? ORDER BY c0_.sort_order ASC, c0_.id ASC, c1_.sort_order ASC, c1_.name ASC
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.code AS code_2, c0_.name AS name_3, c0_.description AS description_4, c0_.is_required AS is_required_5, c0_.is_enabled_by_default AS is_enabled_by_default_6, c0_.sort_order AS sort_order_7, c0_.is_active AS is_active_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c1_.id AS id_11, c1_.name AS name_12, c1_.provider AS provider_13, c1_.purpose AS purpose_14, c1_.expiration AS expiration_15, c1_.is_active AS is_active_16, c1_.sort_order AS sort_order_17, c1_.created_at AS created_at_18, c1_.updated_at AS updated_at_19, c1_.category_id AS category_id_20 FROM cubestudio_cookie_category c0_ LEFT JOIN cubestudio_cookie_item c1_ ON c0_.id = c1_.category_id WHERE c0_.is_active = ? ORDER BY c0_.sort_order ASC, c0_.id ASC, c1_.sort_order ASC, c1_.name ASC
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ItemDomain	15
App\Entity\ProductMedia	7
App\Entity\Product	5
App\Entity\ProductItem	5
App\Entity\Item	5
App\Entity\ProductTranslation	5
App\Entity\ProductDomain	4
App\Entity\Domain	3
App\Entity\Category	2
App\Entity\CategoryTranslation	2
App\Entity\Eshop	1
App\Entity\Currency	1
App\Entity\Country	1
Entities Mapping

Class	Mapping errors
App\Entity\Domain	No errors.
App\Entity\Eshop	No errors.
App\Entity\Currency	No errors.
App\Entity\Country	No errors.
App\Entity\Product	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\ProductDomain	No errors.
App\Entity\ProductItem	No errors.
App\Entity\ProductMedia	No errors.
App\Entity\Category	No errors.
App\Entity\FeatureValue	No errors.
App\Entity\ProductBenefit	No errors.
App\Entity\Showroom	No errors.
App\Entity\ConfigGroup	No errors.
App\Entity\ConfigTag	No errors.
App\Entity\Item	No errors.
App\Entity\Color	No errors.
App\Entity\ProductMediaTranslation	No errors.
App\Entity\ItemDomain	No errors.
App\Entity\ItemTranslation	No errors.
App\Entity\ConfigGroupTranslation	No errors.
App\Entity\ConfigOption	No errors.
App\Entity\ConfigOptionColor	No errors.
App\Entity\ConfigOptionBundle	No errors.
App\Entity\ConfigOptionTag	No errors.
App\Entity\ShopSetting	No errors.
App\Entity\Banner	No errors.
App\Entity\CategoryTranslation	No errors.
CubeStudio\MenuBundle\Entity\Menu	No errors.
App\Entity\Benefit	No errors.
CubeStudio\CookieBundle\Entity\CookieConfig	No errors.
CubeStudio\CookieBundle\Entity\CookieCategory	No errors.
CubeStudio\CookieBundle\Entity\CookieItem	No errors.
Symfony Profiler

GET http://futon-at.cuba.cube-studio.cz/produkt/010.

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
