Symfony Profiler

Query Metrics

26 Database Queries

15 Different statements

281.88 ms Query time

0 Invalid entities

8600 Managed entities

Grouped Statements

Time▼	Count	Info
243.80 ms (86.49%)	3	SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s0_.code AS code_18, s0_.tree_left AS tree_left_19, s0_.tree_right AS tree_right_20, s0_.tree_level AS tree_level_21, s0_.position AS position_22, s0_.enabled AS enabled_23, s0_.id AS id_24, s0_.created_at AS created_at_25, s0_.updated_at AS updated_at_26, s0_.apiLastModifiedAt AS apiLastModifiedAt_27, s0_.showChildren AS showChildren_28, s0_.productListingType AS productListingType_29, s0_.displayStyle AS displayStyle_30, s0_.apiParentId AS apiParentId_31, s0_.apiOrder AS apiOrder_32, s0_.apiId AS apiId_33, s0_.apiValue AS apiValue_34, s0_.includeInLatestProducts AS includeInLatestProducts_35, s1_.name AS name_36, s1_.description AS description_37, s1_.id AS id_38, s1_.url AS url_39, s1_.cmsContent AS cmsContent_40, s1_.slug AS slug_41, s1_.locale AS locale_42, s2_.code AS code_43, s2_.tree_left AS tree_left_44, s2_.tree_right AS tree_right_45, s2_.tree_level AS tree_level_46, s2_.position AS position_47, s2_.enabled AS enabled_48, s2_.id AS id_49, s2_.created_at AS created_at_50, s2_.updated_at AS updated_at_51, s2_.apiLastModifiedAt AS apiLastModifiedAt_52, s2_.showChildren AS showChildren_53, s2_.productListingType AS productListingType_54, s2_.displayStyle AS displayStyle_55, s2_.apiParentId AS apiParentId_56, s2_.apiOrder AS apiOrder_57, s2_.apiId AS apiId_58, s2_.apiValue AS apiValue_59, s2_.includeInLatestProducts AS includeInLatestProducts_60, s0_.tree_root AS tree_root_61, s0_.parent_id AS parent_id_62, s1_.translatable_id AS translatable_id_63, s2_.tree_root AS tree_root_64, s2_.parent_id AS parent_id_65 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.tree_root = ? ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC Parameters: [`"en_US" 1`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s0_.code AS code_18, s0_.tree_left AS tree_left_19, s0_.tree_right AS tree_right_20, s0_.tree_level AS tree_level_21, s0_.position AS position_22, s0_.enabled AS enabled_23, s0_.id AS id_24, s0_.created_at AS created_at_25, s0_.updated_at AS updated_at_26, s0_.apiLastModifiedAt AS apiLastModifiedAt_27, s0_.showChildren AS showChildren_28, s0_.productListingType AS productListingType_29, s0_.displayStyle AS displayStyle_30, s0_.apiParentId AS apiParentId_31, s0_.apiOrder AS apiOrder_32, s0_.apiId AS apiId_33, s0_.apiValue AS apiValue_34, s0_.includeInLatestProducts AS includeInLatestProducts_35, s1_.name AS name_36, s1_.description AS description_37, s1_.id AS id_38, s1_.url AS url_39, s1_.cmsContent AS cmsContent_40, s1_.slug AS slug_41, s1_.locale AS locale_42, s2_.code AS code_43, s2_.tree_left AS tree_left_44, s2_.tree_right AS tree_right_45, s2_.tree_level AS tree_level_46, s2_.position AS position_47, s2_.enabled AS enabled_48, s2_.id AS id_49, s2_.created_at AS created_at_50, s2_.updated_at AS updated_at_51, s2_.apiLastModifiedAt AS apiLastModifiedAt_52, s2_.showChildren AS showChildren_53, s2_.productListingType AS productListingType_54, s2_.displayStyle AS displayStyle_55, s2_.apiParentId AS apiParentId_56, s2_.apiOrder AS apiOrder_57, s2_.apiId AS apiId_58, s2_.apiValue AS apiValue_59, s2_.includeInLatestProducts AS includeInLatestProducts_60, s0_.tree_root AS tree_root_61, s0_.parent_id AS parent_id_62, s1_.translatable_id AS translatable_id_63, s2_.tree_root AS tree_root_64, s2_.parent_id AS parent_id_65 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.tree_root = ? ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s0_.code AS code_18, s0_.tree_left AS tree_left_19, s0_.tree_right AS tree_right_20, s0_.tree_level AS tree_level_21, s0_.position AS position_22, s0_.enabled AS enabled_23, s0_.id AS id_24, s0_.created_at AS created_at_25, s0_.updated_at AS updated_at_26, s0_.apiLastModifiedAt AS apiLastModifiedAt_27, s0_.showChildren AS showChildren_28, s0_.productListingType AS productListingType_29, s0_.displayStyle AS displayStyle_30, s0_.apiParentId AS apiParentId_31, s0_.apiOrder AS apiOrder_32, s0_.apiId AS apiId_33, s0_.apiValue AS apiValue_34, s0_.includeInLatestProducts AS includeInLatestProducts_35, s1_.name AS name_36, s1_.description AS description_37, s1_.id AS id_38, s1_.url AS url_39, s1_.cmsContent AS cmsContent_40, s1_.slug AS slug_41, s1_.locale AS locale_42, s2_.code AS code_43, s2_.tree_left AS tree_left_44, s2_.tree_right AS tree_right_45, s2_.tree_level AS tree_level_46, s2_.position AS position_47, s2_.enabled AS enabled_48, s2_.id AS id_49, s2_.created_at AS created_at_50, s2_.updated_at AS updated_at_51, s2_.apiLastModifiedAt AS apiLastModifiedAt_52, s2_.showChildren AS showChildren_53, s2_.productListingType AS productListingType_54, s2_.displayStyle AS displayStyle_55, s2_.apiParentId AS apiParentId_56, s2_.apiOrder AS apiOrder_57, s2_.apiId AS apiId_58, s2_.apiValue AS apiValue_59, s2_.includeInLatestProducts AS includeInLatestProducts_60, s0_.tree_root AS tree_root_61, s0_.parent_id AS parent_id_62, s1_.translatable_id AS translatable_id_63, s2_.tree_root AS tree_root_64, s2_.parent_id AS parent_id_65 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = 'en_US' AND s0_.tree_root = 1 ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC;
19.51 ms (6.92%)	1	SELECT DISTINCT s0_.id AS id_0 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) INNER JOIN sylius_product_taxon s2_ ON s0_.id = s2_.product_id INNER JOIN sylius_product_attribute_value s3_ ON s0_.id = s3_.product_id AND (s3_.attribute_id = ? AND s3_.boolean_value = ?) WHERE s2_.taxon_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND EXISTS (SELECT 1 FROM sylius_product_channels s4_ WHERE s4_.product_id = s0_.id AND s4_.channel_id IN (?)) AND s0_.enabled = ? ORDER BY s0_.id ASC Parameters: ["en_US" 142 1 1486 1502 1518 1534 1550 1566 1582 1598 1614 1630 1646 1662 1678 1694 1710 1726 1742 1758 1774 1790 1806 1822 1838 1854 1870 1886 1902 1918 1934 1950 1966 1982 1998 2014 2030 2046 2062 2078 2094 2110 2126 2142 2158 2174 2190 2206 2222 2238 2254 2270 2286 2302 2318 2334 2350 2366 2382 2398 2414 2430 2446 2462 2478 2494 2510 2526 2542 2558 2574 2590 2606 2622 2638 2654 2670 2686 4207 4223 14 30 46 62 78 94 110 126 142 158 174 190 206 222 238 254 270 286 302 318 334 350 366 382 398 414 430 446 462 478 494 510 526 542 558 574 590 606 622 638 654 670 686 702 718 734 750 766 782 798 814 830 846 862 878 894 910 926 942 958 974 990 1006 1022 1038 1054 1070 1086 1102 1118 1134 1150 1166 1182 1198 1214 1230 1246 1262 1278 1294 1310 1326 1342 1358 1374 1390 1406 1422 1438 1454 1470 1487 1503 1519 1535 1551 1567 1583 1599 1615 1631 1647 1663 1679 1695 1711 1727 1743 1759 1775 1791 1807 1823 1839 1855 1871 1887 1903 1919 1935 1951 1967 1983 1999 2015 2031 2047 2063 2079 2095 2111 2127 2143 2159 2175 2191 2207 2223 2239 2255 2271 2287 2303 2319 2335 2351 2367 2383 2399 2415 2431 2447 2463 2479 2495 2511 2527 2543 2559 2575 2591 2607 2623 2639 2655 2671 2687 4208 4224 15 31 47 63 79 95 111 127 143 159 175 191 207 223 239 255 271 287 303 319 335 351 367 383 399 415 431 447 463 479 495 511 527 543 559 575 591 607 623 639 655 671 687 703 719 735 751 767 783 799 815 831 847 863 879 895 911 927 943 959 975 991 1007 1023 1039 1055 1071 1087 1103 1119 1135 1151 1167 1183 1199 1215 1231 1247 1263 1279 1295 1311 1327 1343 1359 1375 1391 1407 1423 1439 1455 1471 1488 1504 1520 1536 1552 1568 1584 1600 1616 1632 1648 1664 1680 1696 1712 1728 1744 1760 1776 1792 1808 1824 1840 1856 1872 1888 1904 1920 1936 1952 1968 1984 2000 2016 2032 2048 2064 2080 2096 2112 2128 2144 2160 2176 2192 2208 2224 2240 2256 2272 2288 2304 2320 2336 2352 2368 2384 2400 2416 2432 2448 2464 2480 2496 2512 2528 2544 2560 2576 2592 2608 2624 2640 2656 2672 2688 4209 4225 16 32 48 64 80 96 112 128 144 160 176 192 208 224 240 256 272 288 304 320 336 352 368 384 400 416 432 448 464 480 496 512 528 544 560 576 592 608 624 640 656 672 688 704 720 736 752 768 784 800 816 832 848 864 880 896 912 928 944 960 976 992 1008 1024 1040 1056 1072 1088 1104 1120 1136 1152 1168 1184 1200 1216 1232 1248 1264 1280 1296 1312 1328 1344 1360 1376 1392 1408 1424 1440 1456 1472 1489 1505 1521 1537 1553 1569 1585 1601 1617 1633 1649 1665 1681 1697 1713 1729 1745 1761 1777 1793 1809 1825 1841 1857 1873 1889 1905 1921 1937 1953 1969 1985 2001 2017 2033 2049 2065 2081 2097 2113 2129 2145 2161 2177 2193 2209 2225 2241 2257 2273 2289 2305 2321 2337 2353 2369 2385 2401 2417 2433 2449 2465 2481 2497 2513 2529 2545 2561 2577 2593 2609 2625 2641 2657 2673 2689 4210 4226 17 33 49 65 81 97 113 129 145 161 177 193 209 225 241 257 273 289 305 321 337 353 369 385 401 417 433 449 465 481 497 513 529 545 561 577 593 609 625 641 657 673 689 705 721 737 753 769 785 801 817 833 849 865 881 897 913 929 945 961 977 993 1009 1025 1041 1057 1073 1089 1105 1121 1137 1153 1169 1185 1201 1217 1233 1249 1265 1281 1297 1313 1329 1345 1361 1377 1393 1409 1425 1441 1457 1473 1490 1506 1522 1538 1554 1570 1586 1602 1618 1634 1650 1666 1682 1698 1714 1730 1746 1762 1778 1794 1810 1826 1842 1858 1874 1890 1906 1922 1938 1954 1970 1986 2002 2018 2034 2050 2066 2082 2098 2114 2130 2146 2162 2178 2194 2210 2226 2242 2258 2274 2290 2306 2322 2338 2354 2370 2386 2402 2418 2434 2450 2466 2482 2498 2514 2530 2546 2562 2578 2594 2610 2626 2642 2658 2674 2690 4211 4227 18 34 50 66 82 98 114 130 146 162 178 194 210 226 242 258 274 290 306 322 338 354 370 386 402 418 434 450 466 482 498 514 530 546 562 578 594 610 626 642 658 674 690 706 722 738 754 770 786 802 818 834 850 866 882 898 914 930 946 962 978 994 1010 1026 1042 1058 1074 1090 1106 1122 1138 1154 1170 1186 1202 1218 1234 1250 1266 1282 1298 1314 1330 1346 1362 1378 1394 1410 1426 1442 1458 1474 1491 1507 1523 1539 1555 1571 1587 1603 1619 1635 1651 1667 1683 1699 1715 1731 1747 1763 1779 1795 1811 1827 1843 1859 1875 1891 1907 1923 1939 1955 1971 1987 2003 2019 2035 2051 2067 2083 2099 2115 2131 2147 2163 2179 2195 2211 2227 2243 2259 2275 2291 2307 2323 2339 2355 2371 2387 2403 2419 2435 2451 2467 2483 2499 2515 2531 2547 2563 2579 2595 2611 2627 2643 2659 2675 2691 4212 4228 19 35 51 67 83 99 115 131 147 163 179 195 211 227 243 259 275 291 307 323 339 355 371 387 403 419 435 451 467 483 499 515 531 547 563 579 595 611 627 643 659 675 691 707 723 739 755 771 787 803 819 835 851 867 883 899 915 931 947 963 979 995 1011 1027 1043 1059 1075 1091 1107 1123 1139 1155 1171 1187 1203 1219 1235 1251 1267 1283 1299 1315 1331 1347 1363 1379 1395 1411 1427 1443 1459 1475 1492 1508 1524 1540 1556 1572 1588 1604 1620 1636 1652 1668 1684 1700 1716 1732 1748 1764 1780 1796 1812 1828 1844 1860 1876 1892 1908 1924 1940 1956 1972 1988 2004 2020 2036 2052 2068 2084 2100 2116 2132 2148 2164 2180 2196 2212 2228 2244 2260 2276 2292 2308 2324 2340 2356 2372 2388 2404 2420 2436 2452 2468 2484 2500 2516 2532 2548 2564 2580 2596 2612 2628 2644 2660 2676 2692 4213 4229 20 36 52 68 84 100 116 132 148 164 180 196 212 228 244 260 276 292 308 324 340 356 372 388 404 420 436 452 468 484 500 516 532 548 564 580 596 612 628 644 660 676 692 708 724 740 756 772 788 804 820 836 852 868 884 900 916 932 948 964 980 996 1012 1028 1044 1060 1076 1092 1108 1124 1140 1156 1172 1188 1204 1220 1236 1252 1268 1284 1300 1316 1332 1348 1364 1380 1396 1412 1428 1444 1460 1476 1493 1509 1525 1541 1557 1573 1589 1605 1621 1637 1653 1669 1685 1701 1717 1733 1749 1765 1781 1797 1813 1829 1845 1861 1877 1893 1909 1925 1941 1957 1973 1989 2005 2021 2037 2053 2069 2085 2101 2117 2133 2149 2165 2181 2197 2213 2229 2245 2261 2277 2293 2309 2325 2341 2357 2373 2389 2405 2421 2437 2453 2469 2485 2501 2517 2533 2549 2565 2581 2597 2613 2629 2645 2661 2677 2693 4198 4214 4287 21 37 53 69 85 101 117 133 149 165 181 197 213 229 245 261 277 293 309 325 341 357 373 389 405 421 437 453 469 485 501 517 533 549 565 581 597 613 629 645 661 677 693 709 725 741 757 773 789 805 821 837 853 869 885 901 917 933 949 965 981 997 1013 1029 1045 1061 1077 1093 1109 1125 1141 1157 1173 1189 1205 1221 1237 1253 1269 1285 1301 1317 1333 1349 1365 1381 1397 1413 1429 1445 1461 1477 1494 1510 1526 1542 1558 1574 1590 1606 1622 1638 1654 1670 1686 1702 1718 1734 1750 1766 1782 1798 1814 1830 1846 1862 1878 1894 1910 1926 1942 1958 1974 1990 2006 2022 2038 2054 2070 2086 2102 2118 2134 2150 2166 2182 2198 2214 2230 2246 2262 2278 2294 2310 2326 2342 2358 2374 2390 2406 2422 2438 2454 2470 2486 2502 2518 2534 2550 2566 2582 2598 2614 2630 2646 2662 2678 2694 4199 4215 22 38 54 70 86 102 118 134 150 166 182 198 214 230 246 262 278 294 310 326 342 358 374 390 406 422 438 454 470 486 502 518 534 550 566 582 598 614 630 646 662 678 694 710 726 742 758 774 790 806 822 838 854 870 886 902 918 934 950 966 982 998 1014 1030 1046 1062 1078 1094 1110 1126 1142 1158 1174 1190 1206 1222 1238 1254 1270 1286 1302 1318 1334 1350 1366 1382 1398 1414 1430 1446 1462 1478 1495 1511 1527 1543 1559 1575 1591 1607 1623 1639 1655 1671 1687 1703 1719 1735 1751 1767 1783 1799 1815 1831 1847 1863 1879 1895 1911 1927 1943 1959 1975 1991 2007 2023 2039 2055 2071 2087 2103 2119 2135 2151 2167 2183 2199 2215 2231 2247 2263 2279 2295 2311 2327 2343 2359 2375 2391 2407 2423 2439 2455 2471 2487 2503 2519 2535 2551 2567 2583 2599 2615 2631 2647 2663 2679 2695 4200 4216 23 39 55 71 87 103 119 135 151 167 183 199 215 231 247 263 279 295 311 327 343 359 375 391 407 423 439 455 471 487 503 519 535 551 567 583 599 615 631 647 663 679 695 711 727 743 759 775 791 807 823 839 855 871 887 903 919 935 951 967 983 999 1015 1031 1047 1063 1079 1095 1111 1127 1143 1159 1175 1191 1207 1223 1239 1255 1271 1287 1303 1319 1335 1351 1367 1383 1399 1415 1431 1447 1463 1479 1496 1512 1528 1544 1560 1576 1592 1608 1624 1640 1656 1672 1688 1704 1720 1736 1752 1768 1784 1800 1816 1832 1848 1864 1880 1896 1912 1928 1944 1960 1976 1992 2008 2024 2040 2056 2072 2088 2104 2120 2136 2152 2168 2184 2200 2216 2232 2248 2264 2280 2296 2312 2328 2344 2360 2376 2392 2408 2424 2440 2456 2472 2488 2504 2520 2536 2552 2568 2584 2600 2616 2632 2648 2664 2680 2696 4201 4217 24 40 56 72 88 104 120 136 152 168 184 200 216 232 248 264 280 296 312 328 344 360 376 392 408 424 440 456 472 488 504 520 536 552 568 584 600 616 632 648 664 680 696 712 728 744 760 776 792 808 824 840 856 872 888 904 920 936 952 968 984 1000 1016 1032 1048 1064 1080 1096 1112 1128 1144 1160 1176 1192 1208 1224 1240 1256 1272 1288 1304 1320 1336 1352 1368 1384 1400 1416 1432 1448 1464 1480 1497 1513 1529 1545 1561 1577 1593 1609 1625 1641 1657 1673 1689 1705 1721 1737 1753 1769 1785 1801 1817 1833 1849 1865 1881 1897 1913 1929 1945 1961 1977 1993 2009 2025 2041 2057 2073 2089 2105 2121 2137 2153 2169 2185 2201 2217 2233 2249 2265 2281 2297 2313 2329 2345 2361 2377 2393 2409 2425 2441 2457 2473 2489 2505 2521 2537 2553 2569 2585 2601 2617 2633 2649 2665 2681 2697 4202 4218 25 41 57 73 89 105 121 137 153 169 185 201 217 233 249 265 281 297 313 329 345 361 377 393 409 425 441 457 473 489 505 521 537 553 569 585 601 617 633 649 665 681 697 713 729 745 761 777 793 809 825 841 857 873 889 905 921 937 953 969 985 1001 1017 1033 1049 1065 1081 1097 1113 1129 1145 1161 1177 1193 1209 1225 1241 1257 1273 1289 1305 1321 1337 1353 1369 1385 1401 1417 1433 1449 1465 1481 1498 1514 1530 1546 1562 1578 1594 1610 1626 1642 1658 1674 1690 1706 1722 1738 1754 1770 1786 1802 1818 1834 1850 1866 1882 1898 1914 1930 1946 1962 1978 1994 2010 2026 2042 2058 2074 2090 2106 2122 2138 2154 2170 2186 2202 2218 2234 2250 2266 2282 2298 2314 2330 2346 2362 2378 2394 2410 2426 2442 2458 2474 2490 2506 2522 2538 2554 2570 2586 2602 2618 2634 2650 2666 2682 2698 4203 4219 8 26 42 58 74 90 106 122 138 154 170 186 202 218 234 250 266 282 298 314 330 346 362 378 394 410 426 442 458 474 490 506 522 538 554 570 586 602 618 634 650 666 682 698 714 730 746 762 778 794 810 826 842 858 874 890 906 922 938 954 970 986 1002 1018 1034 1050 1066 1082 1098 1114 1130 1146 1162 1178 1194 1210 1226 1242 1258 1274 1290 1306 1322 1338 1354 1370 1386 1402 1418 1434 1450 1466 1482 1499 1515 1531 1547 1563 1579 1595 1611 1627 1643 1659 1675 1691 1707 1723 1739 1755 1771 1787 1803 1819 1835 1851 1867 1883 1899 1915 1931 1947 1963 1979 1995 2011 2027 2043 2059 2075 2091 2107 2123 2139 2155 2171 2187 2203 2219 2235 2251 2267 2283 2299 2315 2331 2347 2363 2379 2395 2411 2427 2443 2459 2475 2491 2507 2523 2539 2555 2571 2587 2603 2619 2635 2651 2667 2683 2699 4204 4220 27 43 59 75 91 107 123 139 155 171 187 203 219 235 251 267 283 299 315 331 347 363 379 395 411 427 443 459 475 491 507 523 539 555 571 587 603 619 635 651 667 683 699 715 731 747 763 779 795 811 827 843 859 875 891 907 923 939 955 971 987 1003 1019 1035 1051 1067 1083 1099 1115 1131 1147 1163 1179 1195 1211 1227 1243 1259 1275 1291 1307 1323 1339 1355 1371 1387 1403 1419 1435 1451 1467 1483 1500 1516 1532 1548 1564 1580 1596 1612 1628 1644 1660 1676 1692 1708 1724 1740 1756 1772 1788 1804 1820 1836 1852 1868 1884 1900 1916 1932 1948 1964 1980 1996 2012 2028 2044 2060 2076 2092 2108 2124 2140 2156 2172 2188 2204 2220 2236 2252 2268 2284 2300 2316 2332 2348 2364 2380 2396 2412 2428 2444 2460 2476 2492 2508 2524 2540 2556 2572 2588 2604 2620 2636 2652 2668 2684 2700 4205 4221 28 44 60 76 92 108 124 140 156 172 188 204 220 236 252 268 284 300 316 332 348 364 380 396 412 428 444 460 476 492 508 524 540 556 572 588 604 620 636 652 668 684 700 716 732 748 764 780 796 812 828 844 860 876 892 908 924 940 956 972 988 1004 1020 1036 1052 1068 1084 1100 1116 1132 1148 1164 1180 1196 1212 1228 1244 1260 1276 1292 1308 1324 1340 1356 1372 1388 1404 1420 1436 1452 1468 1484 1501 1517 1533 1549 1565 1581 1597 1613 1629 1645 1661 1677 1693 1709 1725 1741 1757 1773 1789 1805 1821 1837 1853 1869 1885 1901 1917 1933 1949 1965 1981 1997 2013 2029 2045 2061 2077 2093 2109 2125 2141 2157 2173 2189 2205 2221 2237 2253 2269 2285 2301 2317 2333 2349 2365 2381 2397 2413 2429 2445 2461 2477 2493 2509 2525 2541 2557 2573 2589 2605 2621 2637 2653 2669 2685 2701 4206 4222 29 45 61 77 93 109 125 141 157 173 189 205 221 237 253 269 285 301 317 333 349 365 381 397 413 429 445 461 477 493 509 525 541 557 573 589 605 621 637 653 669 685 701 717 733 749 765 781 797 813 829 845 861 877 893 909 925 941 957 973 989 1005 1021 1037 1053 1069 1085 1101 1117 1133 1149 1165 1181 1197 1213 1229 1245 1261 1277 1293 1309 1325 1341 1357 1373 1389 1405 1421 1437 1453 1469 1485 2702 2718 2734 2750 2766 4239 4255 2703 2719 2735 2751 2767 4240 4256 2704 2720 2736 2752 2768 4241 4257 2705 2721 2737 2753 2769 4242 4258 2706 2722 2738 2754 2770 4243 4259 2707 2723 2739 2755 2771 4244 4260 2708 2724 2740 2756 2772 4245 4261 2709 2725 2741 2757 2773 4230 4246 2710 2726 2742 2758 2774 4231 4247 4288 2711 2727 2743 2759 2775 4232 4248 4289 2712 2728 2744 2760 2776 4233 4249 2713 2729 2745 2761 4234 4250 2714 2730 2746 2762 4235 4251 2715 2731 2747 2763 4236 4252 9 2716 2732 2748 2764 4237 4253 2717 2733 2749 2765 4238 4254 2782 4191 2783 4192 2784 4193 2785 4194 2786 4195 2787 4196 2788 4197 2789 2790 2791 2792 2777 2793 2778 2794 2779 2795 2780 2796 10 2781 4184 13 1 1] View formatted query View runnable query Explain query SELECT DISTINCT s0_.id AS id_0 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) INNER JOIN sylius_product_taxon s2_ ON s0_.id = s2_.product_id INNER JOIN sylius_product_attribute_value s3_ ON s0_.id = s3_.product_id AND ( s3_.attribute_id = ? AND s3_.boolean_value = ? ) WHERE s2_.taxon_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND EXISTS ( SELECT 1 FROM sylius_product_channels s4_ WHERE s4_.product_id = s0_.id AND s4_.channel_id IN (?) ) AND s0_.enabled = ? ORDER BY s0_.id ASC SELECT DISTINCT s0_.id AS id_0 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'en_US') INNER JOIN sylius_product_taxon s2_ ON s0_.id = s2_.product_id INNER JOIN sylius_product_attribute_value s3_ ON s0_.id = s3_.product_id AND (s3_.attribute_id = 142 AND s3_.boolean_value = 1) WHERE s2_.taxon_id IN (1486, 1502, 1518, 1534, 1550, 1566, 1582, 1598, 1614, 1630, 1646, 1662, 1678, 1694, 1710, 1726, 1742, 1758, 1774, 1790, 1806, 1822, 1838, 1854, 1870, 1886, 1902, 1918, 1934, 1950, 1966, 1982, 1998, 2014, 2030, 2046, 2062, 2078, 2094, 2110, 2126, 2142, 2158, 2174, 2190, 2206, 2222, 2238, 2254, 2270, 2286, 2302, 2318, 2334, 2350, 2366, 2382, 2398, 2414, 2430, 2446, 2462, 2478, 2494, 2510, 2526, 2542, 2558, 2574, 2590, 2606, 2622, 2638, 2654, 2670, 2686, 4207, 4223, 14, 30, 46, 62, 78, 94, 110, 126, 142, 158, 174, 190, 206, 222, 238, 254, 270, 286, 302, 318, 334, 350, 366, 382, 398, 414, 430, 446, 462, 478, 494, 510, 526, 542, 558, 574, 590, 606, 622, 638, 654, 670, 686, 702, 718, 734, 750, 766, 782, 798, 814, 830, 846, 862, 878, 894, 910, 926, 942, 958, 974, 990, 1006, 1022, 1038, 1054, 1070, 1086, 1102, 1118, 1134, 1150, 1166, 1182, 1198, 1214, 1230, 1246, 1262, 1278, 1294, 1310, 1326, 1342, 1358, 1374, 1390, 1406, 1422, 1438, 1454, 1470, 1487, 1503, 1519, 1535, 1551, 1567, 1583, 1599, 1615, 1631, 1647, 1663, 1679, 1695, 1711, 1727, 1743, 1759, 1775, 1791, 1807, 1823, 1839, 1855, 1871, 1887, 1903, 1919, 1935, 1951, 1967, 1983, 1999, 2015, 2031, 2047, 2063, 2079, 2095, 2111, 2127, 2143, 2159, 2175, 2191, 2207, 2223, 2239, 2255, 2271, 2287, 2303, 2319, 2335, 2351, 2367, 2383, 2399, 2415, 2431, 2447, 2463, 2479, 2495, 2511, 2527, 2543, 2559, 2575, 2591, 2607, 2623, 2639, 2655, 2671, 2687, 4208, 4224, 15, 31, 47, 63, 79, 95, 111, 127, 143, 159, 175, 191, 207, 223, 239, 255, 271, 287, 303, 319, 335, 351, 367, 383, 399, 415, 431, 447, 463, 479, 495, 511, 527, 543, 559, 575, 591, 607, 623, 639, 655, 671, 687, 703, 719, 735, 751, 767, 783, 799, 815, 831, 847, 863, 879, 895, 911, 927, 943, 959, 975, 991, 1007, 1023, 1039, 1055, 1071, 1087, 1103, 1119, 1135, 1151, 1167, 1183, 1199, 1215, 1231, 1247, 1263, 1279, 1295, 1311, 1327, 1343, 1359, 1375, 1391, 1407, 1423, 1439, 1455, 1471, 1488, 1504, 1520, 1536, 1552, 1568, 1584, 1600, 1616, 1632, 1648, 1664, 1680, 1696, 1712, 1728, 1744, 1760, 1776, 1792, 1808, 1824, 1840, 1856, 1872, 1888, 1904, 1920, 1936, 1952, 1968, 1984, 2000, 2016, 2032, 2048, 2064, 2080, 2096, 2112, 2128, 2144, 2160, 2176, 2192, 2208, 2224, 2240, 2256, 2272, 2288, 2304, 2320, 2336, 2352, 2368, 2384, 2400, 2416, 2432, 2448, 2464, 2480, 2496, 2512, 2528, 2544, 2560, 2576, 2592, 2608, 2624, 2640, 2656, 2672, 2688, 4209, 4225, 16, 32, 48, 64, 80, 96, 112, 128, 144, 160, 176, 192, 208, 224, 240, 256, 272, 288, 304, 320, 336, 352, 368, 384, 400, 416, 432, 448, 464, 480, 496, 512, 528, 544, 560, 576, 592, 608, 624, 640, 656, 672, 688, 704, 720, 736, 752, 768, 784, 800, 816, 832, 848, 864, 880, 896, 912, 928, 944, 960, 976, 992, 1008, 1024, 1040, 1056, 1072, 1088, 1104, 1120, 1136, 1152, 1168, 1184, 1200, 1216, 1232, 1248, 1264, 1280, 1296, 1312, 1328, 1344, 1360, 1376, 1392, 1408, 1424, 1440, 1456, 1472, 1489, 1505, 1521, 1537, 1553, 1569, 1585, 1601, 1617, 1633, 1649, 1665, 1681, 1697, 1713, 1729, 1745, 1761, 1777, 1793, 1809, 1825, 1841, 1857, 1873, 1889, 1905, 1921, 1937, 1953, 1969, 1985, 2001, 2017, 2033, 2049, 2065, 2081, 2097, 2113, 2129, 2145, 2161, 2177, 2193, 2209, 2225, 2241, 2257, 2273, 2289, 2305, 2321, 2337, 2353, 2369, 2385, 2401, 2417, 2433, 2449, 2465, 2481, 2497, 2513, 2529, 2545, 2561, 2577, 2593, 2609, 2625, 2641, 2657, 2673, 2689, 4210, 4226, 17, 33, 49, 65, 81, 97, 113, 129, 145, 161, 177, 193, 209, 225, 241, 257, 273, 289, 305, 321, 337, 353, 369, 385, 401, 417, 433, 449, 465, 481, 497, 513, 529, 545, 561, 577, 593, 609, 625, 641, 657, 673, 689, 705, 721, 737, 753, 769, 785, 801, 817, 833, 849, 865, 881, 897, 913, 929, 945, 961, 977, 993, 1009, 1025, 1041, 1057, 1073, 1089, 1105, 1121, 1137, 1153, 1169, 1185, 1201, 1217, 1233, 1249, 1265, 1281, 1297, 1313, 1329, 1345, 1361, 1377, 1393, 1409, 1425, 1441, 1457, 1473, 1490, 1506, 1522, 1538, 1554, 1570, 1586, 1602, 1618, 1634, 1650, 1666, 1682, 1698, 1714, 1730, 1746, 1762, 1778, 1794, 1810, 1826, 1842, 1858, 1874, 1890, 1906, 1922, 1938, 1954, 1970, 1986, 2002, 2018, 2034, 2050, 2066, 2082, 2098, 2114, 2130, 2146, 2162, 2178, 2194, 2210, 2226, 2242, 2258, 2274, 2290, 2306, 2322, 2338, 2354, 2370, 2386, 2402, 2418, 2434, 2450, 2466, 2482, 2498, 2514, 2530, 2546, 2562, 2578, 2594, 2610, 2626, 2642, 2658, 2674, 2690, 4211, 4227, 18, 34, 50, 66, 82, 98, 114, 130, 146, 162, 178, 194, 210, 226, 242, 258, 274, 290, 306, 322, 338, 354, 370, 386, 402, 418, 434, 450, 466, 482, 498, 514, 530, 546, 562, 578, 594, 610, 626, 642, 658, 674, 690, 706, 722, 738, 754, 770, 786, 802, 818, 834, 850, 866, 882, 898, 914, 930, 946, 962, 978, 994, 1010, 1026, 1042, 1058, 1074, 1090, 1106, 1122, 1138, 1154, 1170, 1186, 1202, 1218, 1234, 1250, 1266, 1282, 1298, 1314, 1330, 1346, 1362, 1378, 1394, 1410, 1426, 1442, 1458, 1474, 1491, 1507, 1523, 1539, 1555, 1571, 1587, 1603, 1619, 1635, 1651, 1667, 1683, 1699, 1715, 1731, 1747, 1763, 1779, 1795, 1811, 1827, 1843, 1859, 1875, 1891, 1907, 1923, 1939, 1955, 1971, 1987, 2003, 2019, 2035, 2051, 2067, 2083, 2099, 2115, 2131, 2147, 2163, 2179, 2195, 2211, 2227, 2243, 2259, 2275, 2291, 2307, 2323, 2339, 2355, 2371, 2387, 2403, 2419, 2435, 2451, 2467, 2483, 2499, 2515, 2531, 2547, 2563, 2579, 2595, 2611, 2627, 2643, 2659, 2675, 2691, 4212, 4228, 19, 35, 51, 67, 83, 99, 115, 131, 147, 163, 179, 195, 211, 227, 243, 259, 275, 291, 307, 323, 339, 355, 371, 387, 403, 419, 435, 451, 467, 483, 499, 515, 531, 547, 563, 579, 595, 611, 627, 643, 659, 675, 691, 707, 723, 739, 755, 771, 787, 803, 819, 835, 851, 867, 883, 899, 915, 931, 947, 963, 979, 995, 1011, 1027, 1043, 1059, 1075, 1091, 1107, 1123, 1139, 1155, 1171, 1187, 1203, 1219, 1235, 1251, 1267, 1283, 1299, 1315, 1331, 1347, 1363, 1379, 1395, 1411, 1427, 1443, 1459, 1475, 1492, 1508, 1524, 1540, 1556, 1572, 1588, 1604, 1620, 1636, 1652, 1668, 1684, 1700, 1716, 1732, 1748, 1764, 1780, 1796, 1812, 1828, 1844, 1860, 1876, 1892, 1908, 1924, 1940, 1956, 1972, 1988, 2004, 2020, 2036, 2052, 2068, 2084, 2100, 2116, 2132, 2148, 2164, 2180, 2196, 2212, 2228, 2244, 2260, 2276, 2292, 2308, 2324, 2340, 2356, 2372, 2388, 2404, 2420, 2436, 2452, 2468, 2484, 2500, 2516, 2532, 2548, 2564, 2580, 2596, 2612, 2628, 2644, 2660, 2676, 2692, 4213, 4229, 20, 36, 52, 68, 84, 100, 116, 132, 148, 164, 180, 196, 212, 228, 244, 260, 276, 292, 308, 324, 340, 356, 372, 388, 404, 420, 436, 452, 468, 484, 500, 516, 532, 548, 564, 580, 596, 612, 628, 644, 660, 676, 692, 708, 724, 740, 756, 772, 788, 804, 820, 836, 852, 868, 884, 900, 916, 932, 948, 964, 980, 996, 1012, 1028, 1044, 1060, 1076, 1092, 1108, 1124, 1140, 1156, 1172, 1188, 1204, 1220, 1236, 1252, 1268, 1284, 1300, 1316, 1332, 1348, 1364, 1380, 1396, 1412, 1428, 1444, 1460, 1476, 1493, 1509, 1525, 1541, 1557, 1573, 1589, 1605, 1621, 1637, 1653, 1669, 1685, 1701, 1717, 1733, 1749, 1765, 1781, 1797, 1813, 1829, 1845, 1861, 1877, 1893, 1909, 1925, 1941, 1957, 1973, 1989, 2005, 2021, 2037, 2053, 2069, 2085, 2101, 2117, 2133, 2149, 2165, 2181, 2197, 2213, 2229, 2245, 2261, 2277, 2293, 2309, 2325, 2341, 2357, 2373, 2389, 2405, 2421, 2437, 2453, 2469, 2485, 2501, 2517, 2533, 2549, 2565, 2581, 2597, 2613, 2629, 2645, 2661, 2677, 2693, 4198, 4214, 4287, 21, 37, 53, 69, 85, 101, 117, 133, 149, 165, 181, 197, 213, 229, 245, 261, 277, 293, 309, 325, 341, 357, 373, 389, 405, 421, 437, 453, 469, 485, 501, 517, 533, 549, 565, 581, 597, 613, 629, 645, 661, 677, 693, 709, 725, 741, 757, 773, 789, 805, 821, 837, 853, 869, 885, 901, 917, 933, 949, 965, 981, 997, 1013, 1029, 1045, 1061, 1077, 1093, 1109, 1125, 1141, 1157, 1173, 1189, 1205, 1221, 1237, 1253, 1269, 1285, 1301, 1317, 1333, 1349, 1365, 1381, 1397, 1413, 1429, 1445, 1461, 1477, 1494, 1510, 1526, 1542, 1558, 1574, 1590, 1606, 1622, 1638, 1654, 1670, 1686, 1702, 1718, 1734, 1750, 1766, 1782, 1798, 1814, 1830, 1846, 1862, 1878, 1894, 1910, 1926, 1942, 1958, 1974, 1990, 2006, 2022, 2038, 2054, 2070, 2086, 2102, 2118, 2134, 2150, 2166, 2182, 2198, 2214, 2230, 2246, 2262, 2278, 2294, 2310, 2326, 2342, 2358, 2374, 2390, 2406, 2422, 2438, 2454, 2470, 2486, 2502, 2518, 2534, 2550, 2566, 2582, 2598, 2614, 2630, 2646, 2662, 2678, 2694, 4199, 4215, 22, 38, 54, 70, 86, 102, 118, 134, 150, 166, 182, 198, 214, 230, 246, 262, 278, 294, 310, 326, 342, 358, 374, 390, 406, 422, 438, 454, 470, 486, 502, 518, 534, 550, 566, 582, 598, 614, 630, 646, 662, 678, 694, 710, 726, 742, 758, 774, 790, 806, 822, 838, 854, 870, 886, 902, 918, 934, 950, 966, 982, 998, 1014, 1030, 1046, 1062, 1078, 1094, 1110, 1126, 1142, 1158, 1174, 1190, 1206, 1222, 1238, 1254, 1270, 1286, 1302, 1318, 1334, 1350, 1366, 1382, 1398, 1414, 1430, 1446, 1462, 1478, 1495, 1511, 1527, 1543, 1559, 1575, 1591, 1607, 1623, 1639, 1655, 1671, 1687, 1703, 1719, 1735, 1751, 1767, 1783, 1799, 1815, 1831, 1847, 1863, 1879, 1895, 1911, 1927, 1943, 1959, 1975, 1991, 2007, 2023, 2039, 2055, 2071, 2087, 2103, 2119, 2135, 2151, 2167, 2183, 2199, 2215, 2231, 2247, 2263, 2279, 2295, 2311, 2327, 2343, 2359, 2375, 2391, 2407, 2423, 2439, 2455, 2471, 2487, 2503, 2519, 2535, 2551, 2567, 2583, 2599, 2615, 2631, 2647, 2663, 2679, 2695, 4200, 4216, 23, 39, 55, 71, 87, 103, 119, 135, 151, 167, 183, 199, 215, 231, 247, 263, 279, 295, 311, 327, 343, 359, 375, 391, 407, 423, 439, 455, 471, 487, 503, 519, 535, 551, 567, 583, 599, 615, 631, 647, 663, 679, 695, 711, 727, 743, 759, 775, 791, 807, 823, 839, 855, 871, 887, 903, 919, 935, 951, 967, 983, 999, 1015, 1031, 1047, 1063, 1079, 1095, 1111, 1127, 1143, 1159, 1175, 1191, 1207, 1223, 1239, 1255, 1271, 1287, 1303, 1319, 1335, 1351, 1367, 1383, 1399, 1415, 1431, 1447, 1463, 1479, 1496, 1512, 1528, 1544, 1560, 1576, 1592, 1608, 1624, 1640, 1656, 1672, 1688, 1704, 1720, 1736, 1752, 1768, 1784, 1800, 1816, 1832, 1848, 1864, 1880, 1896, 1912, 1928, 1944, 1960, 1976, 1992, 2008, 2024, 2040, 2056, 2072, 2088, 2104, 2120, 2136, 2152, 2168, 2184, 2200, 2216, 2232, 2248, 2264, 2280, 2296, 2312, 2328, 2344, 2360, 2376, 2392, 2408, 2424, 2440, 2456, 2472, 2488, 2504, 2520, 2536, 2552, 2568, 2584, 2600, 2616, 2632, 2648, 2664, 2680, 2696, 4201, 4217, 24, 40, 56, 72, 88, 104, 120, 136, 152, 168, 184, 200, 216, 232, 248, 264, 280, 296, 312, 328, 344, 360, 376, 392, 408, 424, 440, 456, 472, 488, 504, 520, 536, 552, 568, 584, 600, 616, 632, 648, 664, 680, 696, 712, 728, 744, 760, 776, 792, 808, 824, 840, 856, 872, 888, 904, 920, 936, 952, 968, 984, 1000, 1016, 1032, 1048, 1064, 1080, 1096, 1112, 1128, 1144, 1160, 1176, 1192, 1208, 1224, 1240, 1256, 1272, 1288, 1304, 1320, 1336, 1352, 1368, 1384, 1400, 1416, 1432, 1448, 1464, 1480, 1497, 1513, 1529, 1545, 1561, 1577, 1593, 1609, 1625, 1641, 1657, 1673, 1689, 1705, 1721, 1737, 1753, 1769, 1785, 1801, 1817, 1833, 1849, 1865, 1881, 1897, 1913, 1929, 1945, 1961, 1977, 1993, 2009, 2025, 2041, 2057, 2073, 2089, 2105, 2121, 2137, 2153, 2169, 2185, 2201, 2217, 2233, 2249, 2265, 2281, 2297, 2313, 2329, 2345, 2361, 2377, 2393, 2409, 2425, 2441, 2457, 2473, 2489, 2505, 2521, 2537, 2553, 2569, 2585, 2601, 2617, 2633, 2649, 2665, 2681, 2697, 4202, 4218, 25, 41, 57, 73, 89, 105, 121, 137, 153, 169, 185, 201, 217, 233, 249, 265, 281, 297, 313, 329, 345, 361, 377, 393, 409, 425, 441, 457, 473, 489, 505, 521, 537, 553, 569, 585, 601, 617, 633, 649, 665, 681, 697, 713, 729, 745, 761, 777, 793, 809, 825, 841, 857, 873, 889, 905, 921, 937, 953, 969, 985, 1001, 1017, 1033, 1049, 1065, 1081, 1097, 1113, 1129, 1145, 1161, 1177, 1193, 1209, 1225, 1241, 1257, 1273, 1289, 1305, 1321, 1337, 1353, 1369, 1385, 1401, 1417, 1433, 1449, 1465, 1481, 1498, 1514, 1530, 1546, 1562, 1578, 1594, 1610, 1626, 1642, 1658, 1674, 1690, 1706, 1722, 1738, 1754, 1770, 1786, 1802, 1818, 1834, 1850, 1866, 1882, 1898, 1914, 1930, 1946, 1962, 1978, 1994, 2010, 2026, 2042, 2058, 2074, 2090, 2106, 2122, 2138, 2154, 2170, 2186, 2202, 2218, 2234, 2250, 2266, 2282, 2298, 2314, 2330, 2346, 2362, 2378, 2394, 2410, 2426, 2442, 2458, 2474, 2490, 2506, 2522, 2538, 2554, 2570, 2586, 2602, 2618, 2634, 2650, 2666, 2682, 2698, 4203, 4219, 8, 26, 42, 58, 74, 90, 106, 122, 138, 154, 170, 186, 202, 218, 234, 250, 266, 282, 298, 314, 330, 346, 362, 378, 394, 410, 426, 442, 458, 474, 490, 506, 522, 538, 554, 570, 586, 602, 618, 634, 650, 666, 682, 698, 714, 730, 746, 762, 778, 794, 810, 826, 842, 858, 874, 890, 906, 922, 938, 954, 970, 986, 1002, 1018, 1034, 1050, 1066, 1082, 1098, 1114, 1130, 1146, 1162, 1178, 1194, 1210, 1226, 1242, 1258, 1274, 1290, 1306, 1322, 1338, 1354, 1370, 1386, 1402, 1418, 1434, 1450, 1466, 1482, 1499, 1515, 1531, 1547, 1563, 1579, 1595, 1611, 1627, 1643, 1659, 1675, 1691, 1707, 1723, 1739, 1755, 1771, 1787, 1803, 1819, 1835, 1851, 1867, 1883, 1899, 1915, 1931, 1947, 1963, 1979, 1995, 2011, 2027, 2043, 2059, 2075, 2091, 2107, 2123, 2139, 2155, 2171, 2187, 2203, 2219, 2235, 2251, 2267, 2283, 2299, 2315, 2331, 2347, 2363, 2379, 2395, 2411, 2427, 2443, 2459, 2475, 2491, 2507, 2523, 2539, 2555, 2571, 2587, 2603, 2619, 2635, 2651, 2667, 2683, 2699, 4204, 4220, 27, 43, 59, 75, 91, 107, 123, 139, 155, 171, 187, 203, 219, 235, 251, 267, 283, 299, 315, 331, 347, 363, 379, 395, 411, 427, 443, 459, 475, 491, 507, 523, 539, 555, 571, 587, 603, 619, 635, 651, 667, 683, 699, 715, 731, 747, 763, 779, 795, 811, 827, 843, 859, 875, 891, 907, 923, 939, 955, 971, 987, 1003, 1019, 1035, 1051, 1067, 1083, 1099, 1115, 1131, 1147, 1163, 1179, 1195, 1211, 1227, 1243, 1259, 1275, 1291, 1307, 1323, 1339, 1355, 1371, 1387, 1403, 1419, 1435, 1451, 1467, 1483, 1500, 1516, 1532, 1548, 1564, 1580, 1596, 1612, 1628, 1644, 1660, 1676, 1692, 1708, 1724, 1740, 1756, 1772, 1788, 1804, 1820, 1836, 1852, 1868, 1884, 1900, 1916, 1932, 1948, 1964, 1980, 1996, 2012, 2028, 2044, 2060, 2076, 2092, 2108, 2124, 2140, 2156, 2172, 2188, 2204, 2220, 2236, 2252, 2268, 2284, 2300, 2316, 2332, 2348, 2364, 2380, 2396, 2412, 2428, 2444, 2460, 2476, 2492, 2508, 2524, 2540, 2556, 2572, 2588, 2604, 2620, 2636, 2652, 2668, 2684, 2700, 4205, 4221, 28, 44, 60, 76, 92, 108, 124, 140, 156, 172, 188, 204, 220, 236, 252, 268, 284, 300, 316, 332, 348, 364, 380, 396, 412, 428, 444, 460, 476, 492, 508, 524, 540, 556, 572, 588, 604, 620, 636, 652, 668, 684, 700, 716, 732, 748, 764, 780, 796, 812, 828, 844, 860, 876, 892, 908, 924, 940, 956, 972, 988, 1004, 1020, 1036, 1052, 1068, 1084, 1100, 1116, 1132, 1148, 1164, 1180, 1196, 1212, 1228, 1244, 1260, 1276, 1292, 1308, 1324, 1340, 1356, 1372, 1388, 1404, 1420, 1436, 1452, 1468, 1484, 1501, 1517, 1533, 1549, 1565, 1581, 1597, 1613, 1629, 1645, 1661, 1677, 1693, 1709, 1725, 1741, 1757, 1773, 1789, 1805, 1821, 1837, 1853, 1869, 1885, 1901, 1917, 1933, 1949, 1965, 1981, 1997, 2013, 2029, 2045, 2061, 2077, 2093, 2109, 2125, 2141, 2157, 2173, 2189, 2205, 2221, 2237, 2253, 2269, 2285, 2301, 2317, 2333, 2349, 2365, 2381, 2397, 2413, 2429, 2445, 2461, 2477, 2493, 2509, 2525, 2541, 2557, 2573, 2589, 2605, 2621, 2637, 2653, 2669, 2685, 2701, 4206, 4222, 29, 45, 61, 77, 93, 109, 125, 141, 157, 173, 189, 205, 221, 237, 253, 269, 285, 301, 317, 333, 349, 365, 381, 397, 413, 429, 445, 461, 477, 493, 509, 525, 541, 557, 573, 589, 605, 621, 637, 653, 669, 685, 701, 717, 733, 749, 765, 781, 797, 813, 829, 845, 861, 877, 893, 909, 925, 941, 957, 973, 989, 1005, 1021, 1037, 1053, 1069, 1085, 1101, 1117, 1133, 1149, 1165, 1181, 1197, 1213, 1229, 1245, 1261, 1277, 1293, 1309, 1325, 1341, 1357, 1373, 1389, 1405, 1421, 1437, 1453, 1469, 1485, 2702, 2718, 2734, 2750, 2766, 4239, 4255, 2703, 2719, 2735, 2751, 2767, 4240, 4256, 2704, 2720, 2736, 2752, 2768, 4241, 4257, 2705, 2721, 2737, 2753, 2769, 4242, 4258, 2706, 2722, 2738, 2754, 2770, 4243, 4259, 2707, 2723, 2739, 2755, 2771, 4244, 4260, 2708, 2724, 2740, 2756, 2772, 4245, 4261, 2709, 2725, 2741, 2757, 2773, 4230, 4246, 2710, 2726, 2742, 2758, 2774, 4231, 4247, 4288, 2711, 2727, 2743, 2759, 2775, 4232, 4248, 4289, 2712, 2728, 2744, 2760, 2776, 4233, 4249, 2713, 2729, 2745, 2761, 4234, 4250, 2714, 2730, 2746, 2762, 4235, 4251, 2715, 2731, 2747, 2763, 4236, 4252, 9, 2716, 2732, 2748, 2764, 4237, 4253, 2717, 2733, 2749, 2765, 4238, 4254, 2782, 4191, 2783, 4192, 2784, 4193, 2785, 4194, 2786, 4195, 2787, 4196, 2788, 4197, 2789, 2790, 2791, 2792, 2777, 2793, 2778, 2794, 2779, 2795, 2780, 2796, 10, 2781, 4184, 13) AND EXISTS (SELECT 1 FROM sylius_product_channels s4_ WHERE s4_.product_id = s0_.id AND s4_.channel_id IN (1)) AND s0_.enabled = 1 ORDER BY s0_.id ASC;
5.64 ms (2.00%)	1	SELECT DISTINCT s0_.id AS id_0 FROM sylius_taxon s1_ INNER JOIN sylius_taxon_translation s2_ ON s1_.id = s2_.translatable_id AND (s2_.locale = ?) INNER JOIN sylius_taxon s0_ ON (s0_.id = s1_.id OR (s0_.tree_left >= s1_.tree_left AND s0_.tree_right <= s1_.tree_right AND s0_.tree_root = s1_.tree_root)) WHERE s1_.id IN (?, ?, ?, ?) ORDER BY s1_.id ASC Parameters: [`"en_US" 9 8 13 10`] View formatted query View runnable query Explain query SELECT DISTINCT s0_.id AS id_0 FROM sylius_taxon s1_ INNER JOIN sylius_taxon_translation s2_ ON s1_.id = s2_.translatable_id AND (s2_.locale = ?) INNER JOIN sylius_taxon s0_ ON ( s0_.id = s1_.id OR ( s0_.tree_left >= s1_.tree_left AND s0_.tree_right <= s1_.tree_right AND s0_.tree_root = s1_.tree_root ) ) WHERE s1_.id IN (?, ?, ?, ?) ORDER BY s1_.id ASC SELECT DISTINCT s0_.id AS id_0 FROM sylius_taxon s1_ INNER JOIN sylius_taxon_translation s2_ ON s1_.id = s2_.translatable_id AND (s2_.locale = 'en_US') INNER JOIN sylius_taxon s0_ ON (s0_.id = s1_.id OR (s0_.tree_left >= s1_.tree_left AND s0_.tree_right <= s1_.tree_right AND s0_.tree_root = s1_.tree_root)) WHERE s1_.id IN (9, 8, 13, 10) ORDER BY s1_.id ASC;
2.88 ms (1.02%)	2	SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s1_.name AS name_18, s1_.description AS description_19, s1_.id AS id_20, s1_.url AS url_21, s1_.cmsContent AS cmsContent_22, s1_.slug AS slug_23, s1_.locale AS locale_24, s2_.code AS code_25, s2_.tree_left AS tree_left_26, s2_.tree_right AS tree_right_27, s2_.tree_level AS tree_level_28, s2_.position AS position_29, s2_.enabled AS enabled_30, s2_.id AS id_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, s2_.apiLastModifiedAt AS apiLastModifiedAt_34, s2_.showChildren AS showChildren_35, s2_.productListingType AS productListingType_36, s2_.displayStyle AS displayStyle_37, s2_.apiParentId AS apiParentId_38, s2_.apiOrder AS apiOrder_39, s2_.apiId AS apiId_40, s2_.apiValue AS apiValue_41, s2_.includeInLatestProducts AS includeInLatestProducts_42, s0_.tree_root AS tree_root_43, s0_.parent_id AS parent_id_44, s1_.translatable_id AS translatable_id_45, s2_.tree_root AS tree_root_46, s2_.parent_id AS parent_id_47 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? AND s0_.includeInLatestProducts = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC Parameters: [`"en_US" 1 "main" 1`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s1_.name AS name_18, s1_.description AS description_19, s1_.id AS id_20, s1_.url AS url_21, s1_.cmsContent AS cmsContent_22, s1_.slug AS slug_23, s1_.locale AS locale_24, s2_.code AS code_25, s2_.tree_left AS tree_left_26, s2_.tree_right AS tree_right_27, s2_.tree_level AS tree_level_28, s2_.position AS position_29, s2_.enabled AS enabled_30, s2_.id AS id_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, s2_.apiLastModifiedAt AS apiLastModifiedAt_34, s2_.showChildren AS showChildren_35, s2_.productListingType AS productListingType_36, s2_.displayStyle AS displayStyle_37, s2_.apiParentId AS apiParentId_38, s2_.apiOrder AS apiOrder_39, s2_.apiId AS apiId_40, s2_.apiValue AS apiValue_41, s2_.includeInLatestProducts AS includeInLatestProducts_42, s0_.tree_root AS tree_root_43, s0_.parent_id AS parent_id_44, s1_.translatable_id AS translatable_id_45, s2_.tree_root AS tree_root_46, s2_.parent_id AS parent_id_47 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? AND s0_.includeInLatestProducts = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s1_.name AS name_18, s1_.description AS description_19, s1_.id AS id_20, s1_.url AS url_21, s1_.cmsContent AS cmsContent_22, s1_.slug AS slug_23, s1_.locale AS locale_24, s2_.code AS code_25, s2_.tree_left AS tree_left_26, s2_.tree_right AS tree_right_27, s2_.tree_level AS tree_level_28, s2_.position AS position_29, s2_.enabled AS enabled_30, s2_.id AS id_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, s2_.apiLastModifiedAt AS apiLastModifiedAt_34, s2_.showChildren AS showChildren_35, s2_.productListingType AS productListingType_36, s2_.displayStyle AS displayStyle_37, s2_.apiParentId AS apiParentId_38, s2_.apiOrder AS apiOrder_39, s2_.apiId AS apiId_40, s2_.apiValue AS apiValue_41, s2_.includeInLatestProducts AS includeInLatestProducts_42, s0_.tree_root AS tree_root_43, s0_.parent_id AS parent_id_44, s1_.translatable_id AS translatable_id_45, s2_.tree_root AS tree_root_46, s2_.parent_id AS parent_id_47 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = 'en_US' AND s0_.enabled = 1 AND s3_.code = 'main' AND s0_.includeInLatestProducts = 1 ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC;
2.58 ms (0.91%)	1	SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s1_.name AS name_18, s1_.description AS description_19, s1_.id AS id_20, s1_.url AS url_21, s1_.cmsContent AS cmsContent_22, s1_.slug AS slug_23, s1_.locale AS locale_24, s2_.code AS code_25, s2_.tree_left AS tree_left_26, s2_.tree_right AS tree_right_27, s2_.tree_level AS tree_level_28, s2_.position AS position_29, s2_.enabled AS enabled_30, s2_.id AS id_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, s2_.apiLastModifiedAt AS apiLastModifiedAt_34, s2_.showChildren AS showChildren_35, s2_.productListingType AS productListingType_36, s2_.displayStyle AS displayStyle_37, s2_.apiParentId AS apiParentId_38, s2_.apiOrder AS apiOrder_39, s2_.apiId AS apiId_40, s2_.apiValue AS apiValue_41, s2_.includeInLatestProducts AS includeInLatestProducts_42, s0_.tree_root AS tree_root_43, s0_.parent_id AS parent_id_44, s1_.translatable_id AS translatable_id_45, s2_.tree_root AS tree_root_46, s2_.parent_id AS parent_id_47 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC Parameters: [`"en_US" 1 "main"`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s1_.name AS name_18, s1_.description AS description_19, s1_.id AS id_20, s1_.url AS url_21, s1_.cmsContent AS cmsContent_22, s1_.slug AS slug_23, s1_.locale AS locale_24, s2_.code AS code_25, s2_.tree_left AS tree_left_26, s2_.tree_right AS tree_right_27, s2_.tree_level AS tree_level_28, s2_.position AS position_29, s2_.enabled AS enabled_30, s2_.id AS id_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, s2_.apiLastModifiedAt AS apiLastModifiedAt_34, s2_.showChildren AS showChildren_35, s2_.productListingType AS productListingType_36, s2_.displayStyle AS displayStyle_37, s2_.apiParentId AS apiParentId_38, s2_.apiOrder AS apiOrder_39, s2_.apiId AS apiId_40, s2_.apiValue AS apiValue_41, s2_.includeInLatestProducts AS includeInLatestProducts_42, s0_.tree_root AS tree_root_43, s0_.parent_id AS parent_id_44, s1_.translatable_id AS translatable_id_45, s2_.tree_root AS tree_root_46, s2_.parent_id AS parent_id_47 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.apiLastModifiedAt AS apiLastModifiedAt_9, s0_.showChildren AS showChildren_10, s0_.productListingType AS productListingType_11, s0_.displayStyle AS displayStyle_12, s0_.apiParentId AS apiParentId_13, s0_.apiOrder AS apiOrder_14, s0_.apiId AS apiId_15, s0_.apiValue AS apiValue_16, s0_.includeInLatestProducts AS includeInLatestProducts_17, s1_.name AS name_18, s1_.description AS description_19, s1_.id AS id_20, s1_.url AS url_21, s1_.cmsContent AS cmsContent_22, s1_.slug AS slug_23, s1_.locale AS locale_24, s2_.code AS code_25, s2_.tree_left AS tree_left_26, s2_.tree_right AS tree_right_27, s2_.tree_level AS tree_level_28, s2_.position AS position_29, s2_.enabled AS enabled_30, s2_.id AS id_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, s2_.apiLastModifiedAt AS apiLastModifiedAt_34, s2_.showChildren AS showChildren_35, s2_.productListingType AS productListingType_36, s2_.displayStyle AS displayStyle_37, s2_.apiParentId AS apiParentId_38, s2_.apiOrder AS apiOrder_39, s2_.apiId AS apiId_40, s2_.apiValue AS apiValue_41, s2_.includeInLatestProducts AS includeInLatestProducts_42, s0_.tree_root AS tree_root_43, s0_.parent_id AS parent_id_44, s1_.translatable_id AS translatable_id_45, s2_.tree_root AS tree_root_46, s2_.parent_id AS parent_id_47 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = 'en_US' AND s0_.enabled = 1 AND s3_.code = 'main' ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC;
1.61 ms (0.57%)	4	SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC;
1.59 ms (0.56%)	3	SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.code AS code_2, m0_.is_system AS is_system_3, m0_.id AS id_4, m1_.created_at AS created_at_5, m1_.updated_at AS updated_at_6, m1_.position AS position_7, m1_.target_blank AS target_blank_8, m1_.noreferrer AS noreferrer_9, m1_.noopener AS noopener_10, m1_.nofollow AS nofollow_11, m1_.id AS id_12, m2_.locale AS locale_13, m2_.url AS url_14, m2_.label AS label_15, m2_.id AS id_16, m1_.menu_id AS menu_id_17, m1_.parent_id AS parent_id_18, m2_.translatable_id AS translatable_id_19 FROM monsieurbiz_menu m0_ INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id AND (m2_.locale = ?) WHERE m0_.code = ? ORDER BY m0_.id ASC, m1_.position ASC Parameters: [`"en_US" "top"`] View formatted query View runnable query Explain query SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.code AS code_2, m0_.is_system AS is_system_3, m0_.id AS id_4, m1_.created_at AS created_at_5, m1_.updated_at AS updated_at_6, m1_.position AS position_7, m1_.target_blank AS target_blank_8, m1_.noreferrer AS noreferrer_9, m1_.noopener AS noopener_10, m1_.nofollow AS nofollow_11, m1_.id AS id_12, m2_.locale AS locale_13, m2_.url AS url_14, m2_.label AS label_15, m2_.id AS id_16, m1_.menu_id AS menu_id_17, m1_.parent_id AS parent_id_18, m2_.translatable_id AS translatable_id_19 FROM monsieurbiz_menu m0_ INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id AND (m2_.locale = ?) WHERE m0_.code = ? ORDER BY m0_.id ASC, m1_.position ASC SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.code AS code_2, m0_.is_system AS is_system_3, m0_.id AS id_4, m1_.created_at AS created_at_5, m1_.updated_at AS updated_at_6, m1_.position AS position_7, m1_.target_blank AS target_blank_8, m1_.noreferrer AS noreferrer_9, m1_.noopener AS noopener_10, m1_.nofollow AS nofollow_11, m1_.id AS id_12, m2_.locale AS locale_13, m2_.url AS url_14, m2_.label AS label_15, m2_.id AS id_16, m1_.menu_id AS menu_id_17, m1_.parent_id AS parent_id_18, m2_.translatable_id AS translatable_id_19 FROM monsieurbiz_menu m0_ INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id AND (m2_.locale = 'en_US') WHERE m0_.code = 'top' ORDER BY m0_.id ASC, m1_.position ASC;
0.89 ms (0.32%)	2	SELECT m0_.code AS code_0, m0_.enabled AS enabled_1, m0_.publish_at AS publish_at_2, m0_.unpublish_at AS unpublish_at_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.id AS id_6 FROM monsieurbiz_cms_page m0_ LEFT JOIN monsieurbiz_cms_page_translation m1_ ON m0_.id = m1_.translatable_id INNER JOIN monsieurbiz_cms_page_channels m3_ ON m0_.id = m3_.page_id INNER JOIN sylius_channel s2_ ON s2_.id = m3_.channel_id WHERE m1_.locale = ? AND s2_.code = ? AND m0_.enabled = 1 AND m0_.code = ? ORDER BY m0_.id ASC Parameters: [`"en_US" "default" "homepage-main"`] View formatted query View runnable query Explain query SELECT m0_.code AS code_0, m0_.enabled AS enabled_1, m0_.publish_at AS publish_at_2, m0_.unpublish_at AS unpublish_at_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.id AS id_6 FROM monsieurbiz_cms_page m0_ LEFT JOIN monsieurbiz_cms_page_translation m1_ ON m0_.id = m1_.translatable_id INNER JOIN monsieurbiz_cms_page_channels m3_ ON m0_.id = m3_.page_id INNER JOIN sylius_channel s2_ ON s2_.id = m3_.channel_id WHERE m1_.locale = ? AND s2_.code = ? AND m0_.enabled = 1 AND m0_.code = ? ORDER BY m0_.id ASC SELECT m0_.code AS code_0, m0_.enabled AS enabled_1, m0_.publish_at AS publish_at_2, m0_.unpublish_at AS unpublish_at_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.id AS id_6 FROM monsieurbiz_cms_page m0_ LEFT JOIN monsieurbiz_cms_page_translation m1_ ON m0_.id = m1_.translatable_id INNER JOIN monsieurbiz_cms_page_channels m3_ ON m0_.id = m3_.page_id INNER JOIN sylius_channel s2_ ON s2_.id = m3_.channel_id WHERE m1_.locale = 'en_US' AND s2_.code = 'default' AND m0_.enabled = 1 AND m0_.code = 'homepage-main' ORDER BY m0_.id ASC;
0.74 ms (0.26%)	1	SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.certification AS certification_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.base_country_id AS base_country_id_33, t34.code AS code_35, t34.enabled AS enabled_36, t34.id AS id_37, t0.european_zone_id AS european_zone_id_38, t39.code AS code_40, t39.name AS name_41, t39.type AS type_42, t39.scope AS scope_43, t39.id AS id_44, t39.euVatNumberRequired AS euVatNumberRequired_45, t0.shop_billing_data_id AS shop_billing_data_id_46, t0.channel_price_history_config_id AS channel_price_history_config_id_47 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id LEFT JOIN sylius_country t34 ON t0.base_country_id = t34.id LEFT JOIN sylius_zone t39 ON t0.european_zone_id = t39.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1 Parameters: [`"dev.normadoc.fr" 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.certification AS certification_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.base_country_id AS base_country_id_33, t34.code AS code_35, t34.enabled AS enabled_36, t34.id AS id_37, t0.european_zone_id AS european_zone_id_38, t39.code AS code_40, t39.name AS name_41, t39.type AS type_42, t39.scope AS scope_43, t39.id AS id_44, t39.euVatNumberRequired AS euVatNumberRequired_45, t0.shop_billing_data_id AS shop_billing_data_id_46, t0.channel_price_history_config_id AS channel_price_history_config_id_47 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id LEFT JOIN sylius_country t34 ON t0.base_country_id = t34.id LEFT JOIN sylius_zone t39 ON t0.european_zone_id = t39.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.certification AS certification_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.base_country_id AS base_country_id_33, t34.code AS code_35, t34.enabled AS enabled_36, t34.id AS id_37, t0.european_zone_id AS european_zone_id_38, t39.code AS code_40, t39.name AS name_41, t39.type AS type_42, t39.scope AS scope_43, t39.id AS id_44, t39.euVatNumberRequired AS euVatNumberRequired_45, t0.shop_billing_data_id AS shop_billing_data_id_46, t0.channel_price_history_config_id AS channel_price_history_config_id_47 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id LEFT JOIN sylius_country t34 ON t0.base_country_id = t34.id LEFT JOIN sylius_zone t39 ON t0.european_zone_id = t39.id WHERE t0.hostname = 'dev.normadoc.fr' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;
0.72 ms (0.25%)	1	SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s0_.apiLastModifiedAt AS apiLastModifiedAt_7, s0_.lastUpdatedAt AS lastUpdatedAt_8, s0_.author AS author_9, s0_.publishedAt AS publishedAt_10, s0_.releasedAt AS releasedAt_11, s0_.confirmedAt AS confirmedAt_12, s0_.canceledAt AS canceledAt_13, s0_.edition AS edition_14, s0_.coreDocument AS coreDocument_15, s0_.bookCollection AS bookCollection_16, s0_.pageCount AS pageCount_17, s1_.name AS name_18, s1_.slug AS slug_19, s1_.description AS description_20, s1_.meta_keywords AS meta_keywords_21, s1_.meta_description AS meta_description_22, s1_.id AS id_23, s1_.short_description AS short_description_24, s1_.notes AS notes_25, s1_.locale AS locale_26, s0_.main_taxon_id AS main_taxon_id_27, s0_.supplier_id AS supplier_id_28, s1_.translatable_id AS translatable_id_29 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s0_.id IN (?, ?, ?, ?) ORDER BY s0_.id ASC Parameters: [`"en_US" 4806 5868 13459 5928`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s0_.apiLastModifiedAt AS apiLastModifiedAt_7, s0_.lastUpdatedAt AS lastUpdatedAt_8, s0_.author AS author_9, s0_.publishedAt AS publishedAt_10, s0_.releasedAt AS releasedAt_11, s0_.confirmedAt AS confirmedAt_12, s0_.canceledAt AS canceledAt_13, s0_.edition AS edition_14, s0_.coreDocument AS coreDocument_15, s0_.bookCollection AS bookCollection_16, s0_.pageCount AS pageCount_17, s1_.name AS name_18, s1_.slug AS slug_19, s1_.description AS description_20, s1_.meta_keywords AS meta_keywords_21, s1_.meta_description AS meta_description_22, s1_.id AS id_23, s1_.short_description AS short_description_24, s1_.notes AS notes_25, s1_.locale AS locale_26, s0_.main_taxon_id AS main_taxon_id_27, s0_.supplier_id AS supplier_id_28, s1_.translatable_id AS translatable_id_29 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s0_.id IN (?, ?, ?, ?) ORDER BY s0_.id ASC SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s0_.apiLastModifiedAt AS apiLastModifiedAt_7, s0_.lastUpdatedAt AS lastUpdatedAt_8, s0_.author AS author_9, s0_.publishedAt AS publishedAt_10, s0_.releasedAt AS releasedAt_11, s0_.confirmedAt AS confirmedAt_12, s0_.canceledAt AS canceledAt_13, s0_.edition AS edition_14, s0_.coreDocument AS coreDocument_15, s0_.bookCollection AS bookCollection_16, s0_.pageCount AS pageCount_17, s1_.name AS name_18, s1_.slug AS slug_19, s1_.description AS description_20, s1_.meta_keywords AS meta_keywords_21, s1_.meta_description AS meta_description_22, s1_.id AS id_23, s1_.short_description AS short_description_24, s1_.notes AS notes_25, s1_.locale AS locale_26, s0_.main_taxon_id AS main_taxon_id_27, s0_.supplier_id AS supplier_id_28, s1_.translatable_id AS translatable_id_29 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'en_US') WHERE s0_.id IN (4806, 5868, 13459, 5928) ORDER BY s0_.id ASC;
0.51 ms (0.18%)	2	SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.meta_title AS meta_title_4, t0.meta_keywords AS meta_keywords_5, t0.meta_image AS meta_image_6, t0.meta_description AS meta_description_7, t0.id AS id_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 Parameters: [`10 "en_US"`] View formatted query View runnable query Explain query SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.meta_title AS meta_title_4, t0.meta_keywords AS meta_keywords_5, t0.meta_image AS meta_image_6, t0.meta_description AS meta_description_7, t0.id AS id_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 SELECT t0.title AS title_1, t0.content AS content_2, t0.slug AS slug_3, t0.meta_title AS meta_title_4, t0.meta_keywords AS meta_keywords_5, t0.meta_image AS meta_image_6, t0.meta_description AS meta_description_7, t0.id AS id_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM monsieurbiz_cms_page_translation t0 WHERE t0.translatable_id = 10 AND t0.locale = 'en_US' LIMIT 1;
0.46 ms (0.16%)	1	SELECT a0_.id AS id_0, a0_.enabled AS enabled_1, a0_.apiLastModifiedAt AS apiLastModifiedAt_2, a0_.code AS code_3, a0_.name AS name_4, a0_.fullName AS fullName_5, a0_.providesSubscriptions AS providesSubscriptions_6, a0_.position AS position_7, a0_.origin AS origin_8, a0_.isHighlightedOnHomepage AS isHighlightedOnHomepage_9, a0_.createdAt AS createdAt_10, a0_.updatedAt AS updatedAt_11, a0_.mainTaxon_id AS mainTaxon_id_12 FROM app_supplier a0_ LEFT JOIN app_supplier_translation a1_ ON a0_.id = a1_.translatable_id INNER JOIN supplier_channel s3_ ON a0_.id = s3_.supplier_id INNER JOIN sylius_channel s2_ ON s2_.id = s3_.channel_id WHERE a1_.locale = ? AND s2_.code = ? AND a0_.enabled = 1 AND a0_.isHighlightedOnHomepage = 1 ORDER BY a0_.position ASC, a0_.id ASC Parameters: [`"en_US" "default"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.enabled AS enabled_1, a0_.apiLastModifiedAt AS apiLastModifiedAt_2, a0_.code AS code_3, a0_.name AS name_4, a0_.fullName AS fullName_5, a0_.providesSubscriptions AS providesSubscriptions_6, a0_.position AS position_7, a0_.origin AS origin_8, a0_.isHighlightedOnHomepage AS isHighlightedOnHomepage_9, a0_.createdAt AS createdAt_10, a0_.updatedAt AS updatedAt_11, a0_.mainTaxon_id AS mainTaxon_id_12 FROM app_supplier a0_ LEFT JOIN app_supplier_translation a1_ ON a0_.id = a1_.translatable_id INNER JOIN supplier_channel s3_ ON a0_.id = s3_.supplier_id INNER JOIN sylius_channel s2_ ON s2_.id = s3_.channel_id WHERE a1_.locale = ? AND s2_.code = ? AND a0_.enabled = 1 AND a0_.isHighlightedOnHomepage = 1 ORDER BY a0_.position ASC, a0_.id ASC SELECT a0_.id AS id_0, a0_.enabled AS enabled_1, a0_.apiLastModifiedAt AS apiLastModifiedAt_2, a0_.code AS code_3, a0_.name AS name_4, a0_.fullName AS fullName_5, a0_.providesSubscriptions AS providesSubscriptions_6, a0_.position AS position_7, a0_.origin AS origin_8, a0_.isHighlightedOnHomepage AS isHighlightedOnHomepage_9, a0_.createdAt AS createdAt_10, a0_.updatedAt AS updatedAt_11, a0_.mainTaxon_id AS mainTaxon_id_12 FROM app_supplier a0_ LEFT JOIN app_supplier_translation a1_ ON a0_.id = a1_.translatable_id INNER JOIN supplier_channel s3_ ON a0_.id = s3_.supplier_id INNER JOIN sylius_channel s2_ ON s2_.id = s3_.channel_id WHERE a1_.locale = 'en_US' AND s2_.code = 'default' AND a0_.enabled = 1 AND a0_.isHighlightedOnHomepage = 1 ORDER BY a0_.position ASC, a0_.id ASC;
0.39 ms (0.14%)	2	SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.apiLastModifiedAt AS apiLastModifiedAt_4, t0.owner_id AS owner_id_5 FROM app_supplier_image t0 WHERE t0.owner_id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.apiLastModifiedAt AS apiLastModifiedAt_4, t0.owner_id AS owner_id_5 FROM app_supplier_image t0 WHERE t0.owner_id = ? SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.apiLastModifiedAt AS apiLastModifiedAt_4, t0.owner_id AS owner_id_5 FROM app_supplier_image t0 WHERE t0.owner_id = 10;
0.36 ms (0.13%)	1	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ? SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = 1;
0.21 ms (0.08%)	1	SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9 FROM sylius_product_attribute t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"new"`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9 FROM sylius_product_attribute t0 WHERE t0.code = ? LIMIT 1 SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9 FROM sylius_product_attribute t0 WHERE t0.code = 'new' LIMIT 1;

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\Taxonomy\Taxon	4282
App\Entity\Taxonomy\TaxonTranslation	4282
App\Entity\Locale\Locale	4
MonsieurBiz\SyliusMenuPlugin\Entity\MenuItem	4
MonsieurBiz\SyliusMenuPlugin\Entity\MenuItemTranslation	4
App\Entity\Product\Product	4
App\Entity\Product\ProductTranslation	4
App\Entity\Supplier\Supplier	3
MonsieurBiz\SyliusMenuPlugin\Entity\Menu	2
App\Entity\Supplier\SupplierImage	2
MonsieurBiz\SyliusCmsPagePlugin\Entity\Page	2
MonsieurBiz\SyliusCmsPagePlugin\Entity\PageTranslation	2
App\Entity\Channel\Channel	1
App\Entity\Channel\ShopBillingData	1
App\Entity\Channel\ChannelPriceHistoryConfig	1
App\Entity\Currency\Currency	1
App\Entity\Product\ProductAttribute	1

Entities Mapping

Class	Mapping errors
MonsieurBiz\SyliusCmsPagePlugin\Entity\Page	No errors.
Sylius\Component\Order\Model\Order	No errors.
Sylius\Component\Core\Model\Order	No errors.
App\Entity\Order\Order	No errors.
Sylius\Component\Shipping\Model\Shipment	No errors.
Sylius\Component\Core\Model\Shipment	No errors.
App\Entity\Shipping\Shipment	No errors.
Sylius\Component\Customer\Model\Customer	No errors.
Sylius\Component\Core\Model\Customer	No errors.
App\Entity\Customer\Customer	No errors.
Sylius\Component\Customer\Model\CustomerGroup	No errors.
App\Entity\Customer\CustomerGroup	No errors.
Sylius\Component\Channel\Model\Channel	No errors.
Sylius\Component\Core\Model\Channel	No errors.
App\Entity\Channel\Channel	No errors.
Sylius\Component\Locale\Model\Locale	No errors.
App\Entity\Locale\Locale	No errors.
Sylius\Component\Currency\Model\Currency	No errors.
App\Entity\Currency\Currency	No errors.
Sylius\Component\Addressing\Model\Zone	No errors.
App\Entity\Addressing\Zone	No errors.
Sylius\Component\Taxonomy\Model\Taxon	No errors.
Sylius\Component\Core\Model\Taxon	No errors.
App\Entity\Taxonomy\Taxon	No errors.
Sylius\Component\Addressing\Model\Country	No errors.
App\Entity\Addressing\Country	No errors.
Sylius\Component\Core\Model\ShopBillingData	No errors.
App\Entity\Channel\ShopBillingData	No errors.
Sylius\Component\Core\Model\ChannelPriceHistoryConfig	No errors.
App\Entity\Channel\ChannelPriceHistoryConfig	No errors.
App\Entity\Supplier\Supplier	No errors.
MonsieurBiz\SyliusMenuPlugin\Entity\Menu	No errors.
Sylius\Component\Currency\Model\ExchangeRate	No errors.
App\Entity\Currency\ExchangeRate	No errors.
Sylius\Component\Payment\Model\PaymentMethod	No errors.
Sylius\Component\Core\Model\PaymentMethod	No errors.
App\Entity\Payment\PaymentMethod	No errors.
Sylius\Component\Shipping\Model\ShippingMethod	No errors.
Sylius\Component\Core\Model\ShippingMethod	No errors.
App\Entity\Shipping\ShippingMethod	No errors.
MonsieurBiz\SyliusMenuPlugin\Entity\MenuItem	No errors.
MonsieurBiz\SyliusMenuPlugin\Entity\MenuItemTranslation	No errors.
MonsieurBiz\SyliusCmsPagePlugin\Entity\PageTranslation	No errors.
Sylius\Component\Promotion\Model\PromotionCoupon	No errors.
Sylius\Component\Core\Model\PromotionCoupon	No errors.
App\Entity\Promotion\PromotionCoupon	No errors.
App\Entity\File\File	No errors.
App\Entity\File\PrivateFile	No errors.
App\Entity\Order\OrderPrivateFile	No errors.
App\Entity\Invoice\Invoice	No errors.
App\Entity\Company\Company	No errors.
Sylius\Component\Addressing\Model\Address	No errors.
Sylius\Component\Core\Model\Address	No errors.
App\Entity\Addressing\Address	No errors.
Sylius\Component\Payment\Model\Payment	No errors.
Sylius\Component\Core\Model\Payment	No errors.
App\Entity\Payment\Payment	No errors.
Sylius\Component\Promotion\Model\Promotion	No errors.
Sylius\Component\Core\Model\Promotion	No errors.
App\Entity\Promotion\Promotion	No errors.
Sylius\Component\Order\Model\OrderItem	No errors.
Sylius\Component\Core\Model\OrderItem	No errors.
App\Entity\Order\OrderItem	No errors.
Sylius\Component\Order\Model\Adjustment	No errors.
Sylius\Component\Core\Model\Adjustment	No errors.
App\Entity\Order\Adjustment	No errors.
App\Entity\Shipping\ShipmentPrivateFile	No errors.
Sylius\Component\Order\Model\OrderItemUnit	No errors.
Sylius\Component\Core\Model\OrderItemUnit	No errors.
App\Entity\Order\OrderItemUnit	No errors.
App\Entity\Drm\DrmToken	No errors.
App\Entity\Favorites\Favorites	No errors.
Sylius\Component\Product\Model\Product	No errors.
Sylius\Component\Core\Model\Product	No errors.
App\Entity\Product\Product	No errors.
App\Entity\Company\CompanyCustomerPair	No errors.
Sylius\Component\User\Model\User	No errors.
Sylius\Component\Core\Model\ShopUser	No errors.
App\Entity\User\ShopUser	No errors.
Sylius\Component\Addressing\Model\ZoneMember	No errors.
App\Entity\Addressing\ZoneMember	No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation	No errors.
App\Entity\Taxonomy\TaxonTranslation	No errors.
Sylius\Component\Core\Model\Image	No errors.
Sylius\Component\Core\Model\TaxonImage	No errors.
App\Entity\Taxonomy\TaxonImage	No errors.
Sylius\Component\Addressing\Model\Province	No errors.
App\Entity\Addressing\Province	No errors.
App\Entity\Supplier\SupplierImage	No errors.
App\Entity\Subscription\SubscriptionCollection	No errors.
App\Entity\Supplier\SupplierTranslation	No errors.
Payum\Core\Model\GatewayConfig	No errors.
Sylius\Bundle\PayumBundle\Model\GatewayConfig	No errors.
App\Entity\Payment\GatewayConfig	No errors.
Sylius\Component\Payment\Model\PaymentMethodTranslation	No errors.
App\Entity\Payment\PaymentMethodTranslation	No errors.
Sylius\Component\Shipping\Model\ShippingCategory	No errors.
App\Entity\Shipping\ShippingCategory	No errors.
Sylius\Component\Taxation\Model\TaxCategory	No errors.
App\Entity\Taxation\TaxCategory	No errors.
Sylius\Component\Shipping\Model\ShippingMethodTranslation	No errors.
App\Entity\Shipping\ShippingMethodTranslation	No errors.
Sylius\Component\Shipping\Model\ShippingMethodRule	No errors.
App\Entity\Shipping\ShippingMethodRule	No errors.
App\Entity\Invoice\InvoicePrivateFile	No errors.
App\Entity\Company\CompanyImage	No errors.
App\Entity\Keycloak\KeycloakIdentityProviderConfiguration	No errors.
Sylius\Component\Promotion\Model\PromotionTranslation	No errors.
App\Entity\Promotion\PromotionTranslation	No errors.
Sylius\Component\Promotion\Model\PromotionRule	No errors.
App\Entity\Promotion\PromotionRule	No errors.
Sylius\Component\Promotion\Model\PromotionAction	No errors.
App\Entity\Promotion\PromotionAction	No errors.
Sylius\Component\Product\Model\ProductVariant	No errors.
Sylius\Component\Core\Model\ProductVariant	No errors.
App\Entity\Product\ProductVariant	No errors.
App\Entity\Drm\DrmTokenLog	No errors.
App\Entity\Document\Document	No errors.
App\Entity\Product\ProductDocument	No errors.
Sylius\Component\Product\Model\ProductTranslation	No errors.
Sylius\Component\Core\Model\ProductTranslation	No errors.
App\Entity\Product\ProductTranslation	No errors.
Sylius\Component\Core\Model\ProductTaxon	No errors.
App\Entity\Product\ProductTaxon	No errors.
Sylius\Component\Review\Model\Review	No errors.
Sylius\Component\Core\Model\ProductReview	No errors.
App\Entity\Product\ProductReview	No errors.
Sylius\Component\Core\Model\ProductImage	No errors.
App\Entity\Product\ProductImage	No errors.
Sylius\Component\Attribute\Model\AttributeValue	No errors.
Sylius\Component\Product\Model\ProductAttributeValue	No errors.
App\Entity\Product\ProductAttributeValue	No errors.
Sylius\Component\Product\Model\ProductAssociation	No errors.
App\Entity\Product\ProductAssociation	No errors.
Sylius\Component\Product\Model\ProductOption	No errors.
App\Entity\Product\ProductOption	No errors.
Sylius\Component\User\Model\UserOAuth	No errors.
App\Entity\User\UserOAuth	No errors.
Sylius\Component\Taxation\Model\TaxRate	No errors.
Sylius\Component\Core\Model\TaxRate	No errors.
App\Entity\Taxation\TaxRate	No errors.
Sylius\Component\Product\Model\ProductVariantTranslation	No errors.
App\Entity\Product\ProductVariantTranslation	No errors.
Sylius\Component\Core\Model\ChannelPricing	No errors.
App\Entity\Channel\ChannelPricing	No errors.
Sylius\Component\Product\Model\ProductOptionValue	No errors.
App\Entity\Product\ProductOptionValue	No errors.
Sylius\Component\Attribute\Model\Attribute	No errors.
Sylius\Component\Product\Model\ProductAttribute	No errors.
App\Entity\Product\ProductAttribute	No errors.
Sylius\Component\Product\Model\ProductAssociationType	No errors.
App\Entity\Product\ProductAssociationType	No errors.
Sylius\Component\Product\Model\ProductOptionTranslation	No errors.
App\Entity\Product\ProductOptionTranslation	No errors.
Sylius\Component\Promotion\Model\CatalogPromotion	No errors.
Sylius\Component\Core\Model\CatalogPromotion	No errors.
App\Entity\Promotion\CatalogPromotion	No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation	No errors.
App\Entity\Product\ProductOptionValueTranslation	No errors.
Sylius\Component\Attribute\Model\AttributeTranslation	No errors.
Sylius\Component\Product\Model\ProductAttributeTranslation	No errors.
App\Entity\Product\ProductAttributeTranslation	No errors.
Sylius\Component\Product\Model\ProductAssociationTypeTranslation	No errors.
App\Entity\Product\ProductAssociationTypeTranslation	No errors.

Symfony Profiler

GET https://dev.normadoc.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping