Symfony Profiler

Query Metrics

75 Database Queries
26 Different statements
70.02 ms Query time
3 Invalid entities
157 Managed entities
Queries


SELECT e0_.id AS id_0, e0_.exchange_rate AS exchange_rate_1, e0_.last_automatic_update AS last_automatic_update_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.currency_from_id AS currency_from_id_5, e0_.currency_to_id AS currency_to_id_6 FROM exchange_rate e0_
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id ORDER BY c0_.is_default DESC, c0_.code ASC
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.newsletter_consent AS newsletter_consent_14, c0_.gdpr_consent AS gdpr_consent_15, c0_.payment_method AS payment_method_16, c0_.tracking_heureka_opt_out AS tracking_heureka_opt_out_17, c0_.tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.address_street AS address_street_21, c0_.address_descriptive_number AS address_descriptive_number_22, c0_.address_city AS address_city_23, c0_.address_country AS address_country_24, c0_.address_zip_code AS address_zip_code_25, c0_.invoice_street AS invoice_street_26, c0_.invoice_descriptive_number AS invoice_descriptive_number_27, c0_.invoice_city AS invoice_city_28, c0_.invoice_country AS invoice_country_29, c0_.invoice_zip_code AS invoice_zip_code_30, c1_.id AS id_31, c1_.quantity AS quantity_32, c1_.is_gift AS is_gift_33, c1_.created_at AS created_at_34, c1_.updated_at AS updated_at_35, p2_.id AS id_36, p2_.public_id AS public_id_37, p2_.code AS code_38, p2_.is_default AS is_default_39, p2_.weight_modification AS weight_modification_40, p2_.price_modification_amount AS price_modification_amount_41, p2_.price_modification_currency AS price_modification_currency_42, p2_.stock_stock AS stock_stock_43, p2_.stock_reserved AS stock_reserved_44, p3_.id AS id_45, p3_.public_id AS public_id_46, p3_.name AS name_47, p3_.description AS description_48, p3_.short_description AS short_description_49, p3_.code AS code_50, p3_.ean AS ean_51, p3_.unit AS unit_52, p3_.active AS active_53, p3_.can_be_bought AS can_be_bought_54, p3_.searchable AS searchable_55, p3_.show_price AS show_price_56, p3_.in_stock_text AS in_stock_text_57, p3_.out_of_stock_text AS out_of_stock_text_58, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_59, p3_.filter_variant_value_ids AS filter_variant_value_ids_60, p3_.search_vector_cs AS search_vector_cs_61, p3_.search_vector_en AS search_vector_en_62, p3_.seo_title AS seo_title_63, p3_.seo_description AS seo_description_64, p3_.seo_url AS seo_url_65, p3_.stock_stock AS stock_stock_66, p3_.stock_reserved AS stock_reserved_67, p3_.logistic_weight AS logistic_weight_68, p3_.logistic_size_width AS logistic_size_width_69, p3_.logistic_size_height AS logistic_size_height_70, p3_.logistic_size_length AS logistic_size_length_71, p3_.price_amount AS price_amount_72, p3_.price_currency AS price_currency_73, p3_.purchase_price_amount AS purchase_price_amount_74, p3_.purchase_price_currency AS purchase_price_currency_75, c0_.customer_id AS customer_id_76, c0_.shipping_method_id AS shipping_method_id_77, c0_.discount_code_id AS discount_code_id_78, c1_.cart_id AS cart_id_79, c1_.product_variant_id AS product_variant_id_80, p2_.product_id AS product_id_81, p3_.vat_id AS vat_id_82, p3_.main_category_id AS main_category_id_83 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = ? AND c0_.status = ? ORDER BY c1_.id ASC
"START TRANSACTION"
INSERT INTO cart (id, session_id, status, last_activity_at, email, firstname, lastname, telephone, company_name, cin, vat_id, pickup_point_id, pickup_point_name, note, newsletter_consent, gdpr_consent, payment_method, tracking_heureka_opt_out, tracking_zbozi_opt_in, created_at, updated_at, address_street, address_descriptive_number, address_city, address_country, address_zip_code, invoice_street, invoice_descriptive_number, invoice_city, invoice_country, invoice_zip_code, customer_id, shipping_method_id, discount_code_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8, c0_.seo_title AS seo_title_9, c0_.seo_description AS seo_description_10, c0_.seo_url AS seo_url_11, f1_.id AS id_12, f1_.size AS size_13, f1_.mime_type AS mime_type_14, f1_.name AS name_15, c0_.image_id AS image_id_16, c0_.tree_root AS tree_root_17, c0_.parent_id AS parent_id_18 FROM category c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.parent_id IS NULL ORDER BY c0_.position ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.type AS type_2, f0_.is_enabled AS is_enabled_3, p1_.id AS id_4, p1_.name AS name_5, p1_.slug AS slug_6, p1_.position AS position_7, p2_.id AS id_8, p2_.name AS name_9, p2_.slug AS slug_10, p2_.position AS position_11, f0_.entity AS entity_12, f0_.parameter_id AS parameter_id_13, p2_.parameter_id AS parameter_id_14 FROM filter_configuration f0_ LEFT JOIN parameter p1_ ON f0_.parameter_id = p1_.id LEFT JOIN parameter_value p2_ ON p1_.id = p2_.parameter_id WHERE (f0_.is_enabled = ?) AND f0_.entity IN ('parameter') ORDER BY f0_.name ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.type AS type_2, f0_.is_enabled AS is_enabled_3, v1_.id AS id_4, v1_.name AS name_5, v1_.slug AS slug_6, v1_.type AS type_7, v1_.position AS position_8, v2_.id AS id_9, v2_.name AS name_10, v2_.slug AS slug_11, v2_.color AS color_12, v2_.position AS position_13, f0_.entity AS entity_14, f0_.variant_id AS variant_id_15, v2_.variant_id AS variant_id_16 FROM filter_configuration f0_ LEFT JOIN variant v1_ ON f0_.variant_id = v1_.id LEFT JOIN variant_value v2_ ON v1_.id = v2_.variant_id WHERE (f0_.is_enabled = ?) AND f0_.entity IN ('variant') ORDER BY f0_.name ASC
SELECT DISTINCT id_0, MIN(sclr_81) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.public_id AS public_id_1, p0_.name AS name_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.code AS code_5, p0_.ean AS ean_6, p0_.unit AS unit_7, p0_.active AS active_8, p0_.can_be_bought AS can_be_bought_9, p0_.searchable AS searchable_10, p0_.show_price AS show_price_11, p0_.in_stock_text AS in_stock_text_12, p0_.out_of_stock_text AS out_of_stock_text_13, p0_.filter_parameter_value_ids AS filter_parameter_value_ids_14, p0_.filter_variant_value_ids AS filter_variant_value_ids_15, p0_.search_vector_cs AS search_vector_cs_16, p0_.search_vector_en AS search_vector_en_17, p0_.seo_title AS seo_title_18, p0_.seo_description AS seo_description_19, p0_.seo_url AS seo_url_20, p0_.stock_stock AS stock_stock_21, p0_.stock_reserved AS stock_reserved_22, p0_.logistic_weight AS logistic_weight_23, p0_.logistic_size_width AS logistic_size_width_24, p0_.logistic_size_height AS logistic_size_height_25, p0_.logistic_size_length AS logistic_size_length_26, p0_.price_amount AS price_amount_27, p0_.price_currency AS price_currency_28, p0_.purchase_price_amount AS purchase_price_amount_29, p0_.purchase_price_currency AS purchase_price_currency_30, p1_.id AS id_31, p1_.public_id AS public_id_32, p1_.code AS code_33, p1_.is_default AS is_default_34, p1_.weight_modification AS weight_modification_35, p1_.price_modification_amount AS price_modification_amount_36, p1_.price_modification_currency AS price_modification_currency_37, p1_.stock_stock AS stock_stock_38, p1_.stock_reserved AS stock_reserved_39, v2_.id AS id_40, v2_.name AS name_41, v2_.slug AS slug_42, v2_.color AS color_43, v2_.position AS position_44, v3_.id AS id_45, v3_.name AS name_46, v3_.slug AS slug_47, v3_.type AS type_48, v3_.position AS position_49, p4_.id AS id_50, p4_.custom_value AS custom_value_51, p5_.id AS id_52, p5_.name AS name_53, p5_.slug AS slug_54, p5_.position AS position_55, p6_.id AS id_56, p6_.name AS name_57, p6_.slug AS slug_58, p6_.position AS position_59, c7_.id AS id_60, c7_.public_id AS public_id_61, c7_.name AS name_62, c7_.slug AS slug_63, c7_.description AS description_64, c7_.lft AS lft_65, c7_.lvl AS lvl_66, c7_.rgt AS rgt_67, c7_.position AS position_68, c7_.seo_title AS seo_title_69, c7_.seo_description AS seo_description_70, c7_.seo_url AS seo_url_71, p8_.id AS id_72, p8_.amount AS amount_73, p8_.type AS type_74, p8_.created_at AS created_at_75, p8_.updated_at AS updated_at_76, c9_.code AS code_77, c9_.is_default AS is_default_78, c9_.is_active AS is_active_79, c9_.decimal_places AS decimal_places_80, ROW_NUMBER() OVER(ORDER BY (p0_.name ->> ?) ASC, p0_.id ASC) AS sclr_81 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant_variant_value p10_ ON p1_.id = p10_.product_variant_id LEFT JOIN variant_value v2_ ON v2_.id = p10_.variant_value_id LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id LEFT JOIN category c7_ ON p0_.main_category_id = c7_.id LEFT JOIN product_price p8_ ON p0_.id = p8_.product_id LEFT JOIN currency c9_ ON p8_.currency_code = c9_.code WHERE p0_.active = true AND (SELECT COUNT(*) FROM product_category p11_ WHERE p11_.product_id = p0_.id) > 0) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 12
SELECT p0_.id AS id_0, p0_.public_id AS public_id_1, p0_.name AS name_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.code AS code_5, p0_.ean AS ean_6, p0_.unit AS unit_7, p0_.active AS active_8, p0_.can_be_bought AS can_be_bought_9, p0_.searchable AS searchable_10, p0_.show_price AS show_price_11, p0_.in_stock_text AS in_stock_text_12, p0_.out_of_stock_text AS out_of_stock_text_13, p0_.filter_parameter_value_ids AS filter_parameter_value_ids_14, p0_.filter_variant_value_ids AS filter_variant_value_ids_15, p0_.search_vector_cs AS search_vector_cs_16, p0_.search_vector_en AS search_vector_en_17, p0_.seo_title AS seo_title_18, p0_.seo_description AS seo_description_19, p0_.seo_url AS seo_url_20, p0_.stock_stock AS stock_stock_21, p0_.stock_reserved AS stock_reserved_22, p0_.logistic_weight AS logistic_weight_23, p0_.logistic_size_width AS logistic_size_width_24, p0_.logistic_size_height AS logistic_size_height_25, p0_.logistic_size_length AS logistic_size_length_26, p0_.price_amount AS price_amount_27, p0_.price_currency AS price_currency_28, p0_.purchase_price_amount AS purchase_price_amount_29, p0_.purchase_price_currency AS purchase_price_currency_30, p1_.id AS id_31, p1_.public_id AS public_id_32, p1_.code AS code_33, p1_.is_default AS is_default_34, p1_.weight_modification AS weight_modification_35, p1_.price_modification_amount AS price_modification_amount_36, p1_.price_modification_currency AS price_modification_currency_37, p1_.stock_stock AS stock_stock_38, p1_.stock_reserved AS stock_reserved_39, v2_.id AS id_40, v2_.name AS name_41, v2_.slug AS slug_42, v2_.color AS color_43, v2_.position AS position_44, v3_.id AS id_45, v3_.name AS name_46, v3_.slug AS slug_47, v3_.type AS type_48, v3_.position AS position_49, p4_.id AS id_50, p4_.custom_value AS custom_value_51, p5_.id AS id_52, p5_.name AS name_53, p5_.slug AS slug_54, p5_.position AS position_55, p6_.id AS id_56, p6_.name AS name_57, p6_.slug AS slug_58, p6_.position AS position_59, c7_.id AS id_60, c7_.public_id AS public_id_61, c7_.name AS name_62, c7_.slug AS slug_63, c7_.description AS description_64, c7_.lft AS lft_65, c7_.lvl AS lvl_66, c7_.rgt AS rgt_67, c7_.position AS position_68, c7_.seo_title AS seo_title_69, c7_.seo_description AS seo_description_70, c7_.seo_url AS seo_url_71, p8_.id AS id_72, p8_.amount AS amount_73, p8_.type AS type_74, p8_.created_at AS created_at_75, p8_.updated_at AS updated_at_76, c9_.code AS code_77, c9_.is_default AS is_default_78, c9_.is_active AS is_active_79, c9_.decimal_places AS decimal_places_80, p0_.vat_id AS vat_id_81, p0_.main_category_id AS main_category_id_82, p1_.product_id AS product_id_83, v2_.variant_id AS variant_id_84, p4_.product_id AS product_id_85, p4_.parameter_id AS parameter_id_86, p4_.parameter_value_id AS parameter_value_id_87, p6_.parameter_id AS parameter_id_88, c7_.image_id AS image_id_89, c7_.tree_root AS tree_root_90, c7_.parent_id AS parent_id_91, p8_.product_id AS product_id_92, p8_.currency_code AS currency_code_93 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant_variant_value p10_ ON p1_.id = p10_.product_variant_id LEFT JOIN variant_value v2_ ON v2_.id = p10_.variant_value_id LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id LEFT JOIN category c7_ ON p0_.main_category_id = c7_.id LEFT JOIN product_price p8_ ON p0_.id = p8_.product_id LEFT JOIN currency c9_ ON p8_.currency_code = c9_.code WHERE p0_.active = true AND (SELECT COUNT(*) FROM product_category p11_ WHERE p11_.product_id = p0_.id) > 0 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY (p0_.name ->> ?) ASC, p0_.id ASC
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.public_id AS public_id_1, p0_.name AS name_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.code AS code_5, p0_.ean AS ean_6, p0_.unit AS unit_7, p0_.active AS active_8, p0_.can_be_bought AS can_be_bought_9, p0_.searchable AS searchable_10, p0_.show_price AS show_price_11, p0_.in_stock_text AS in_stock_text_12, p0_.out_of_stock_text AS out_of_stock_text_13, p0_.filter_parameter_value_ids AS filter_parameter_value_ids_14, p0_.filter_variant_value_ids AS filter_variant_value_ids_15, p0_.search_vector_cs AS search_vector_cs_16, p0_.search_vector_en AS search_vector_en_17, p0_.seo_title AS seo_title_18, p0_.seo_description AS seo_description_19, p0_.seo_url AS seo_url_20, p0_.stock_stock AS stock_stock_21, p0_.stock_reserved AS stock_reserved_22, p0_.logistic_weight AS logistic_weight_23, p0_.logistic_size_width AS logistic_size_width_24, p0_.logistic_size_height AS logistic_size_height_25, p0_.logistic_size_length AS logistic_size_length_26, p0_.price_amount AS price_amount_27, p0_.price_currency AS price_currency_28, p0_.purchase_price_amount AS purchase_price_amount_29, p0_.purchase_price_currency AS purchase_price_currency_30, p1_.id AS id_31, p1_.public_id AS public_id_32, p1_.code AS code_33, p1_.is_default AS is_default_34, p1_.weight_modification AS weight_modification_35, p1_.price_modification_amount AS price_modification_amount_36, p1_.price_modification_currency AS price_modification_currency_37, p1_.stock_stock AS stock_stock_38, p1_.stock_reserved AS stock_reserved_39, v2_.id AS id_40, v2_.name AS name_41, v2_.slug AS slug_42, v2_.color AS color_43, v2_.position AS position_44, v3_.id AS id_45, v3_.name AS name_46, v3_.slug AS slug_47, v3_.type AS type_48, v3_.position AS position_49, p4_.id AS id_50, p4_.custom_value AS custom_value_51, p5_.id AS id_52, p5_.name AS name_53, p5_.slug AS slug_54, p5_.position AS position_55, p6_.id AS id_56, p6_.name AS name_57, p6_.slug AS slug_58, p6_.position AS position_59, c7_.id AS id_60, c7_.public_id AS public_id_61, c7_.name AS name_62, c7_.slug AS slug_63, c7_.description AS description_64, c7_.lft AS lft_65, c7_.lvl AS lvl_66, c7_.rgt AS rgt_67, c7_.position AS position_68, c7_.seo_title AS seo_title_69, c7_.seo_description AS seo_description_70, c7_.seo_url AS seo_url_71, p8_.id AS id_72, p8_.amount AS amount_73, p8_.type AS type_74, p8_.created_at AS created_at_75, p8_.updated_at AS updated_at_76, c9_.code AS code_77, c9_.is_default AS is_default_78, c9_.is_active AS is_active_79, c9_.decimal_places AS decimal_places_80 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant_variant_value p10_ ON p1_.id = p10_.product_variant_id LEFT JOIN variant_value v2_ ON v2_.id = p10_.variant_value_id LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id LEFT JOIN category c7_ ON p0_.main_category_id = c7_.id LEFT JOIN product_price p8_ ON p0_.id = p8_.product_id LEFT JOIN currency c9_ ON p8_.currency_code = c9_.code WHERE p0_.active = true AND (SELECT COUNT(*) FROM product_category p11_ WHERE p11_.product_id = p0_.id) > 0 ORDER BY (p0_.name ->> ?) ASC, p0_.id ASC) dctrn_result) dctrn_table
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.newsletter_consent AS newsletter_consent_14, c0_.gdpr_consent AS gdpr_consent_15, c0_.payment_method AS payment_method_16, c0_.tracking_heureka_opt_out AS tracking_heureka_opt_out_17, c0_.tracking_zbozi_opt_in AS tracking_zbozi_opt_in_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.address_street AS address_street_21, c0_.address_descriptive_number AS address_descriptive_number_22, c0_.address_city AS address_city_23, c0_.address_country AS address_country_24, c0_.address_zip_code AS address_zip_code_25, c0_.invoice_street AS invoice_street_26, c0_.invoice_descriptive_number AS invoice_descriptive_number_27, c0_.invoice_city AS invoice_city_28, c0_.invoice_country AS invoice_country_29, c0_.invoice_zip_code AS invoice_zip_code_30, c1_.id AS id_31, c1_.quantity AS quantity_32, c1_.is_gift AS is_gift_33, c1_.created_at AS created_at_34, c1_.updated_at AS updated_at_35, p2_.id AS id_36, p2_.public_id AS public_id_37, p2_.code AS code_38, p2_.is_default AS is_default_39, p2_.weight_modification AS weight_modification_40, p2_.price_modification_amount AS price_modification_amount_41, p2_.price_modification_currency AS price_modification_currency_42, p2_.stock_stock AS stock_stock_43, p2_.stock_reserved AS stock_reserved_44, p3_.id AS id_45, p3_.public_id AS public_id_46, p3_.name AS name_47, p3_.description AS description_48, p3_.short_description AS short_description_49, p3_.code AS code_50, p3_.ean AS ean_51, p3_.unit AS unit_52, p3_.active AS active_53, p3_.can_be_bought AS can_be_bought_54, p3_.searchable AS searchable_55, p3_.show_price AS show_price_56, p3_.in_stock_text AS in_stock_text_57, p3_.out_of_stock_text AS out_of_stock_text_58, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_59, p3_.filter_variant_value_ids AS filter_variant_value_ids_60, p3_.search_vector_cs AS search_vector_cs_61, p3_.search_vector_en AS search_vector_en_62, p3_.seo_title AS seo_title_63, p3_.seo_description AS seo_description_64, p3_.seo_url AS seo_url_65, p3_.stock_stock AS stock_stock_66, p3_.stock_reserved AS stock_reserved_67, p3_.logistic_weight AS logistic_weight_68, p3_.logistic_size_width AS logistic_size_width_69, p3_.logistic_size_height AS logistic_size_height_70, p3_.logistic_size_length AS logistic_size_length_71, p3_.price_amount AS price_amount_72, p3_.price_currency AS price_currency_73, p3_.purchase_price_amount AS purchase_price_amount_74, p3_.purchase_price_currency AS purchase_price_currency_75, c0_.customer_id AS customer_id_76, c0_.shipping_method_id AS shipping_method_id_77, c0_.discount_code_id AS discount_code_id_78, c1_.cart_id AS cart_id_79, c1_.product_variant_id AS product_variant_id_80, p2_.product_id AS product_id_81, p3_.vat_id AS vat_id_82, p3_.main_category_id AS main_category_id_83 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = ? AND c0_.status = ? ORDER BY c1_.id ASC
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.position AS position_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_url AS seo_url_12, t0.image_id AS image_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.target AS target_3, d0_.type AS type_4, d0_.value AS value_5, d0_.active_from AS active_from_6, d0_.active_to AS active_to_7, d0_.minimum_quantity AS minimum_quantity_8, d0_.minimum_order_value AS minimum_order_value_9, d0_.active AS active_10, p1_.id AS id_11, p1_.public_id AS public_id_12, p1_.name AS name_13, p1_.description AS description_14, p1_.short_description AS short_description_15, p1_.code AS code_16, p1_.ean AS ean_17, p1_.unit AS unit_18, p1_.active AS active_19, p1_.can_be_bought AS can_be_bought_20, p1_.searchable AS searchable_21, p1_.show_price AS show_price_22, p1_.in_stock_text AS in_stock_text_23, p1_.out_of_stock_text AS out_of_stock_text_24, p1_.filter_parameter_value_ids AS filter_parameter_value_ids_25, p1_.filter_variant_value_ids AS filter_variant_value_ids_26, p1_.search_vector_cs AS search_vector_cs_27, p1_.search_vector_en AS search_vector_en_28, p1_.seo_title AS seo_title_29, p1_.seo_description AS seo_description_30, p1_.seo_url AS seo_url_31, p1_.stock_stock AS stock_stock_32, p1_.stock_reserved AS stock_reserved_33, p1_.logistic_weight AS logistic_weight_34, p1_.logistic_size_width AS logistic_size_width_35, p1_.logistic_size_height AS logistic_size_height_36, p1_.logistic_size_length AS logistic_size_length_37, p1_.price_amount AS price_amount_38, p1_.price_currency AS price_currency_39, p1_.purchase_price_amount AS purchase_price_amount_40, p1_.purchase_price_currency AS purchase_price_currency_41, p2_.id AS id_42, p2_.public_id AS public_id_43, p2_.code AS code_44, p2_.is_default AS is_default_45, p2_.weight_modification AS weight_modification_46, p2_.price_modification_amount AS price_modification_amount_47, p2_.price_modification_currency AS price_modification_currency_48, p2_.stock_stock AS stock_stock_49, p2_.stock_reserved AS stock_reserved_50, c3_.id AS id_51, c3_.public_id AS public_id_52, c3_.name AS name_53, c3_.slug AS slug_54, c3_.description AS description_55, c3_.lft AS lft_56, c3_.lvl AS lvl_57, c3_.rgt AS rgt_58, c3_.position AS position_59, c3_.seo_title AS seo_title_60, c3_.seo_description AS seo_description_61, c3_.seo_url AS seo_url_62, d0_.product_id AS product_id_63, d0_.product_variant_id AS product_variant_id_64, d0_.category_id AS category_id_65, d0_.customer_group_id AS customer_group_id_66, p1_.vat_id AS vat_id_67, p1_.main_category_id AS main_category_id_68, p2_.product_id AS product_id_69, c3_.image_id AS image_id_70, c3_.tree_root AS tree_root_71, c3_.parent_id AS parent_id_72 FROM discount d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_variant p2_ ON d0_.product_variant_id = p2_.id LEFT JOIN category c3_ ON d0_.category_id = c3_.id WHERE d0_.active = ? AND d0_.code IS NULL AND ((d0_.active_from IS NULL OR d0_.active_from <= ?)) AND ((d0_.active_to IS NULL OR d0_.active_to >= ?)) AND d0_.customer_group_id IS NULL AND ((d0_.target = ? AND d0_.product_variant_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR (d0_.target = ? AND d0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) OR (d0_.target = ? AND d0_.category_id IN (SELECT c4_.id FROM category c4_ WHERE EXISTS (SELECT c5_.id FROM category c5_ WHERE c5_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c5_.tree_root = c4_.tree_root AND c5_.lft >= c4_.lft AND c5_.rgt <= c4_.rgt))))
SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_parameter_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY(?)
         GROUP BY unnested_value
SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_parameter_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY(?)
         GROUP BY unnested_value
SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_variant_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY(?)
         GROUP BY unnested_value
SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_variant_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY(?)
         GROUP BY unnested_value
SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_variant_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY(?)
         GROUP BY unnested_value
SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_parameter_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY(?)
         GROUP BY unnested_value
SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_variant_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY(?)
         GROUP BY unnested_value
SELECT n0_.id AS id_0, n0_.active AS active_1, n0_.content AS content_2, n0_.notice_position AS notice_position_3, n0_.show_from AS show_from_4, n0_.show_to AS show_to_5, n0_.background_color AS background_color_6, n0_.text_color AS text_color_7, n0_.button_background_color AS button_background_color_8, n0_.button_hover_background_color AS button_hover_background_color_9, n0_.button_text_color AS button_text_color_10, n0_.notice_type AS notice_type_11 FROM notice n0_ WHERE n0_.notice_type IN ('infobar')
SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8, c0_.seo_title AS seo_title_9, c0_.seo_description AS seo_description_10, c0_.seo_url AS seo_url_11 FROM category c0_ ORDER BY c0_.tree_root ASC, c0_.lft ASC
SELECT s0_.id AS id_0, s0_.public_id AS public_id_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.content AS content_4, s0_.show_contact_form AS show_contact_form_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.seo_title AS seo_title_9, s0_.seo_description AS seo_description_10, s0_.seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_.active = true ORDER BY s0_.created_at ASC
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id ORDER BY c0_.is_default DESC, c0_.code ASC
SELECT s0_.id AS id_0, s0_.public_id AS public_id_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.content AS content_4, s0_.show_contact_form AS show_contact_form_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.seo_title AS seo_title_9, s0_.seo_description AS seo_description_10, s0_.seo_url AS seo_url_11 FROM static_page s0_ WHERE s0_.active = true ORDER BY s0_.created_at ASC
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = ?
SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, c0_.decimal_places AS decimal_places_3, e1_.id AS id_4, e1_.exchange_rate AS exchange_rate_5, e1_.last_automatic_update AS last_automatic_update_6, e1_.created_at AS created_at_7, e1_.updated_at AS updated_at_8, e2_.id AS id_9, e2_.exchange_rate AS exchange_rate_10, e2_.last_automatic_update AS last_automatic_update_11, e2_.created_at AS created_at_12, e2_.updated_at AS updated_at_13, e1_.currency_from_id AS currency_from_id_14, e1_.currency_to_id AS currency_to_id_15, e2_.currency_from_id AS currency_from_id_16, e2_.currency_to_id AS currency_to_id_17 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id ORDER BY c0_.is_default DESC, c0_.code ASC
SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8, c0_.seo_title AS seo_title_9, c0_.seo_description AS seo_description_10, c0_.seo_url AS seo_url_11 FROM category c0_ ORDER BY c0_.tree_root ASC, c0_.lft ASC
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.title AS title_2, s0_.content AS content_3, s0_.link_url AS link_url_4, s0_.link_label AS link_label_5, s0_.is_active AS is_active_6, f1_.id AS id_7, f1_.size AS size_8, f1_.mime_type AS mime_type_9, f1_.name AS name_10, s0_.image_id AS image_id_11 FROM sidebar_block s0_ LEFT JOIN file f1_ ON s0_.image_id = f1_.id WHERE s0_.is_active = true ORDER BY s0_.position ASC, s0_.id ASC
SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.lft AS lft_5, c0_.lvl AS lvl_6, c0_.rgt AS rgt_7, c0_.position AS position_8, c0_.seo_title AS seo_title_9, c0_.seo_description AS seo_description_10, c0_.seo_url AS seo_url_11 FROM category c0_ ORDER BY c0_.tree_root ASC, c0_.lft ASC
SELECT t0.id AS id_1, t0.rate AS rate_2 FROM tax_rate t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.rate AS rate_2 FROM tax_rate t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.position AS position_3, t0.product_id AS product_id_4, t0.file_id AS file_id_5 FROM product_image t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.size AS size_2, t0.mime_type AS mime_type_3, t0.name AS name_4 FROM file t0 WHERE t0.id = ?
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.label AS label_2, f0_.url AS url_3, f0_.is_active AS is_active_4 FROM footer_link f0_ WHERE f0_.is_active = true ORDER BY f0_.position ASC, f0_.id ASC
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.network AS network_2, s0_.url AS url_3, s0_.is_active AS is_active_4 FROM social_link s0_ WHERE s0_.is_active = true ORDER BY s0_.position ASC, s0_.id 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\Product\Domain\Entity\ProductVariant	29
App\File\Domain\Entity\File	23
App\Product\Domain\Entity\ProductImage	20
App\Product\Domain\Entity\Category	18
App\Product\Domain\Entity\Product	12
App\Product\Domain\Entity\VariantValue	8
App\Filter\Domain\Entity\FilterConfiguration	6
App\Product\Domain\Entity\ParameterValue	5
App\Frontoffice\Domain\Entity\FooterLink	5
App\Product\Domain\Entity\ProductParameter	4
App\Frontoffice\Domain\Entity\SocialLink	4
App\Configuration\Domain\Entity\Currency	3
App\Product\Domain\Entity\Parameter	3
App\Product\Domain\Entity\Variant	3
App\Discount\Domain\Entity\Discount	3
App\PageBuilder\Domain\Entity\StaticPage	3
App\Configuration\Domain\Entity\ExchangeRate	2
App\Accounting\Domain\Entity\TaxRate	2
App\Frontoffice\Domain\Entity\SidebarBlock	2
App\Frontoffice\Domain\Entity\Cart	1
App\Configuration\Domain\Entity\Notice	1
Entities Mapping

Class	Mapping errors
App\Configuration\Domain\Entity\Configuration	No errors.
App\Localization\Domain\Entity\Language	No errors.
App\SEO\Domain\Entity\SEO	No errors.
App\Product\Domain\Entity\Stock	No errors.
App\Logistic\Domain\Entity\Size	No errors.
App\Logistic\Domain\Entity\Logistic	No errors.
App\Shared\Domain\Entity\Price	No errors.
App\Product\Domain\Entity\Product	No errors.
App\Product\Domain\Entity\Category	No errors.
App\PageBuilder\Domain\Entity\StaticPage	No errors.
App\Configuration\Domain\Entity\Currency	No errors.
App\Configuration\Domain\Entity\ExchangeRate	No errors.
App\Configuration\Domain\Entity\Notice	No errors.
App\Routing\Domain\Entity\RedirectRoute	No errors.
App\Payment\Domain\Entity\PaymentMethodConfiguration	The field App\Payment\Domain\Entity\PaymentMethodConfiguration#countryConfigurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Payment\Domain\Entity\PaymentMethodCountryConfiguration#paymentMethodConfiguration does not contain the required 'inversedBy: "countryConfigurations"' attribute.
App\Filter\Domain\Entity\FilterConfiguration	No errors.
App\Filter\Domain\Entity\ParameterFilterConfiguration	No errors.
App\Filter\Domain\Entity\VariantFilterConfiguration	No errors.
App\Product\Domain\Entity\ParameterValue	No errors.
App\Product\Domain\Entity\VariantValue	No errors.
App\Discount\Domain\Entity\Discount	No errors.
App\Shared\Domain\Entity\Address	No errors.
App\Frontoffice\Domain\Entity\Cart	No errors.
App\Gift\Domain\Entity\Gift	No errors.
App\Frontoffice\Domain\Entity\CartItem	No errors.
App\Shared\Domain\Entity\NullablePrice	No errors.
App\Product\Domain\Entity\ProductVariant	No errors.
App\Customer\Domain\Entity\Customer	No errors.
App\Shipping\Domain\Entity\ShippingMethod	The field App\Shipping\Domain\Entity\ShippingMethod#fees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Shipping\Domain\Entity\ShippingMethodFee#shippingMethod does not contain the required 'inversedBy: "fees"' attribute.
App\Accounting\Domain\Entity\TaxRate	No errors.
App\File\Domain\Entity\File	No errors.
App\Product\Domain\Entity\Parameter	No errors.
App\Product\Domain\Entity\ProductParameter	No errors.
App\Product\Domain\Entity\Variant	No errors.
App\Product\Domain\Entity\ProductPrice	No errors.
App\Product\Domain\Entity\ProductImage	No errors.
App\Product\Domain\Entity\ProductFile	No errors.
App\Product\Domain\Entity\ProductVideo	No errors.
App\Customer\Domain\Entity\CustomerGroup	The field 'App\Customer\Domain\Entity\CustomerGroup#discount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Configuration\Domain\Entity\InfoBarNotice	No errors.
App\Gdpr\Domain\Entity\CustomerGdprState	No errors.
App\Frontoffice\Domain\Entity\SidebarBlock	No errors.
App\Blog\Domain\Entity\BlogPost	No errors.
App\Frontoffice\Domain\Entity\FooterLink	No errors.
App\Frontoffice\Domain\Entity\SocialLink	No errors.
Symfony Profiler

GET https://poole7f3b5fd.s1.stage.forga.cz/cs/products?page=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
