Query Metrics
62
Database Queries
20
Different statements
110.50 ms
Query time
0
Invalid entities
177
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
15.62 ms (14.13%) |
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.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[ "forges-preprod.kwantic.dev" 1 ] |
|
14.23 ms (12.87%) |
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_.is_new AS is_new_7, s0_.is_iconic AS is_iconic_8, s0_.is_featured AS is_featured_9, s0_.is_engravable AS is_engravable_10, s0_.gravure_max_length AS gravure_max_length_11, s0_.gravure_allowed_chars AS gravure_allowed_chars_12, s0_.code_douane AS code_douane_13, s0_.allow_backorder AS allow_backorder_14, s0_.backorder_delay AS backorder_delay_15, s1_.name AS name_16, s1_.slug AS slug_17, s1_.description AS description_18, s1_.meta_keywords AS meta_keywords_19, s1_.meta_description AS meta_description_20, s1_.id AS id_21, s1_.short_description AS short_description_22, s1_.metaTitle AS metaTitle_23, s1_.metaRobots AS metaRobots_24, s1_.ogTitle AS ogTitle_25, s1_.ogDescription AS ogDescription_26, s1_.ogImage AS ogImage_27, s1_.twitterTitle AS twitterTitle_28, s1_.twitterDescription AS twitterDescription_29, s1_.locale AS locale_30, s2_.type AS type_31, s2_.path AS path_32, s2_.id AS id_33, s2_.position AS position_34, s3_.position AS position_35, s3_.id AS id_36, s4_.code AS code_37, s4_.created_at AS created_at_38, s4_.updated_at AS updated_at_39, s4_.position AS position_40, s4_.enabled AS enabled_41, s4_.id AS id_42, s4_.version AS version_43, s4_.on_hold AS on_hold_44, s4_.on_hand AS on_hand_45, s4_.tracked AS tracked_46, s4_.width AS width_47, s4_.height AS height_48, s4_.depth AS depth_49, s4_.weight AS weight_50, s4_.shipping_required AS shipping_required_51, s4_.recurring AS recurring_52, s4_.recurring_times AS recurring_times_53, s4_.recurring_interval AS recurring_interval_54, s5_.price AS price_55, s5_.original_price AS original_price_56, s5_.minimum_price AS minimum_price_57, s5_.lowest_price_before_discount AS lowest_price_before_discount_58, s5_.channel_code AS channel_code_59, s5_.id AS id_60, s6_.code AS code_61, s6_.id AS id_62, s6_.color AS color_63, s6_.iconName AS iconName_64, s6_.updatedAt AS updatedAt_65, s0_.main_taxon_id AS main_taxon_id_66, s0_.product_type_id AS product_type_id_67, s1_.translatable_id AS translatable_id_68, s2_.owner_id AS owner_id_69, s3_.product_id AS product_id_70, s3_.taxon_id AS taxon_id_71, s4_.product_id AS product_id_72, s4_.tax_category_id AS tax_category_id_73, s4_.shipping_category_id AS shipping_category_id_74, s5_.product_variant_id AS product_variant_id_75, s6_.option_id AS option_id_76 FROM sylius_product s0_ LEFT JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_product_image s2_ ON s0_.id = s2_.owner_id LEFT JOIN sylius_product_taxon s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_product_variant s4_ ON s0_.id = s4_.product_id LEFT JOIN sylius_channel_pricing s5_ ON s4_.id = s5_.product_variant_id LEFT JOIN sylius_product_variant_option_value s7_ ON s4_.id = s7_.variant_id LEFT JOIN sylius_product_option_value s6_ ON s6_.id = s7_.option_value_id WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC, s3_.id ASC, s4_.position ASC, s4_.id ASC, s5_.id ASC, s6_.id ASC
Parameters:
[ 797 798 799 800 801 1131 1132 ] |
|
13.77 ms (12.46%) |
1 |
SELECT s0_.id AS id_0, MIN(s1_.position) AS sclr_1 FROM sylius_product s0_ INNER JOIN sylius_product_channels s3_ ON s0_.id = s3_.product_id INNER JOIN sylius_channel s2_ ON s2_.id = s3_.channel_id INNER JOIN sylius_product_taxon s4_ ON s0_.id = s4_.product_id INNER JOIN sylius_taxon s5_ ON s4_.taxon_id = s5_.id INNER JOIN sylius_product_variant s6_ ON s0_.id = s6_.product_id INNER JOIN sylius_channel_pricing s7_ ON s6_.id = s7_.product_variant_id INNER JOIN sylius_product_taxon s1_ ON s0_.id = s1_.product_id INNER JOIN sylius_taxon s8_ ON s1_.taxon_id = s8_.id WHERE s0_.enabled = 1 AND s2_.code = ? AND s5_.code IN (?) AND s6_.enabled = 1 AND s7_.channel_code = ? AND s7_.price IS NOT NULL AND s8_.code = ? GROUP BY s0_.id ORDER BY sclr_1 ASC
Parameters:
[ "WEB-EU" "tradition_couteaux_speciaux" "WEB-EU" "tradition_couteaux_speciaux" ] |
|
11.82 ms (10.70%) |
3 |
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.owner_id AS owner_id_5 FROM sylius_product_image t0 INNER JOIN sylius_product_image_product_variants ON t0.id = sylius_product_image_product_variants.image_id WHERE sylius_product_image_product_variants.variant_id = ? ORDER BY t0.id ASC
Parameters:
[
973
]
|
|
9.00 ms (8.14%) |
15 |
SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"tradition_couteaux_speciaux"
]
|
|
8.68 ms (7.85%) |
1 |
SELECT s0_.code AS code_0, count(DISTINCT s1_.product_id) AS sclr_1 FROM sylius_product_taxon s1_ INNER JOIN sylius_taxon s0_ ON s1_.taxon_id = s0_.id WHERE s1_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.code
Parameters:
[ 599 601 608 609 613 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 669 670 671 672 673 674 675 676 677 678 679 680 681 682 688 689 690 691 692 693 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 756 757 758 759 771 773 776 784 788 789 790 791 792 795 797 798 799 800 801 802 803 804 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 837 838 839 840 841 842 843 844 845 846 847 848 855 870 874 875 876 877 878 879 880 881 882 883 884 885 886 889 890 891 892 893 894 903 905 906 907 908 909 910 911 912 913 914 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 967 968 970 971 972 973 974 975 976 977 978 979 980 981 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1018 1019 1020 1029 1030 1031 1032 1033 1035 1036 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1084 1086 1095 1096 1103 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1162 1163 1164 1165 1166 1167 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1212 1213 1222 1223 1224 1225 1232 1241 1242 1243 1244 1245 1246 1251 1252 1254 1255 1256 1257 1258 1260 1261 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1277 1279 1284 1285 1286 1287 1288 1289 1290 1293 1294 1300 1301 1304 1305 1306 1307 1308 1309 1310 1311 1312 1314 1315 1318 1321 1322 1324 1327 1330 1331 1332 1333 1334 1335 1336 1337 1338 1093 1340 1345 1346 1347 1348 ] |
|
6.44 ms (5.82%) |
17 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 9 "fr_FR" ] |
|
6.02 ms (5.45%) |
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.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.code = ? LIMIT 1
Parameters:
[
"WEB-EU"
]
|
|
5.16 ms (4.67%) |
1 |
SELECT s0_.id AS id_0 FROM sylius_product s0_ INNER JOIN sylius_product_channels s2_ ON s0_.id = s2_.product_id INNER JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id INNER JOIN sylius_product_variant s3_ ON s0_.id = s3_.product_id INNER JOIN sylius_channel_pricing s4_ ON s3_.id = s4_.product_variant_id WHERE s0_.enabled = 1 AND s1_.code = ? AND s3_.enabled = 1 AND s4_.channel_code = ? AND s4_.price IS NOT NULL GROUP BY s0_.id
Parameters:
[ "WEB-EU" "WEB-EU" ] |
|
4.25 ms (3.84%) |
6 |
SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
13
]
|
|
4.18 ms (3.78%) |
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
]
|
|
2.42 ms (2.19%) |
3 |
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.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id INNER JOIN sylius_product_channels ON t0.id = sylius_product_channels.channel_id WHERE sylius_product_channels.product_id = ? ORDER BY t0.id ASC
Parameters:
[
801
]
|
|
2.37 ms (2.14%) |
3 |
SELECT t0.locale_code AS locale_code_1, t0.text_value AS text_value_2, t0.boolean_value AS boolean_value_3, t0.integer_value AS integer_value_4, t0.float_value AS float_value_5, t0.datetime_value AS datetime_value_6, t0.date_value AS date_value_7, t0.json_value AS json_value_8, t0.id AS id_9, t0.product_id AS product_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_attribute_value t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
801
]
|
|
1.31 ms (1.19%) |
1 |
SELECT s0_.code AS code_0, s1_.code AS code_1, count(DISTINCT s2_.product_id) AS sclr_2 FROM sylius_product_variant s2_ INNER JOIN sylius_product_variant_option_value s3_ ON s2_.id = s3_.variant_id INNER JOIN sylius_product_option_value s1_ ON s1_.id = s3_.option_value_id INNER JOIN sylius_product_option s0_ ON s1_.option_id = s0_.id WHERE s0_.code IN (?) AND s2_.product_id IN (?, ?, ?, ?, ?, ?, ?) AND s2_.enabled = 1 GROUP BY s0_.code, s1_.code
Parameters:
[ "taille" 797 798 799 800 801 1131 1132 ] |
|
1.21 ms (1.10%) |
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, s1_.name AS name_9, s1_.slug AS slug_10, s1_.description AS description_11, s1_.id AS id_12, s1_.metaTitle AS metaTitle_13, s1_.metaRobots AS metaRobots_14, s1_.ogTitle AS ogTitle_15, s1_.ogDescription AS ogDescription_16, s1_.ogImage AS ogImage_17, s1_.twitterTitle AS twitterTitle_18, s1_.twitterDescription AS twitterDescription_19, s1_.metaDescription AS metaDescription_20, s1_.locale AS locale_21, s0_.tree_root AS tree_root_22, s0_.parent_id AS parent_id_23, s1_.translatable_id AS translatable_id_24 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ? ORDER BY s0_.id ASC
Parameters:
[ 1 "tradition/couteaux-speciaux" "fr_FR" ] |
|
1.20 ms (1.09%) |
2 |
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, t0.filterable AS filterable_10 FROM sylius_product_attribute t0 WHERE t0.id = ?
Parameters:
[
24
]
|
|
0.97 ms (0.88%) |
1 |
SELECT s0_.attribute_id AS sclr_0, s0_.text_value AS text_value_1, count(DISTINCT s0_.product_id) AS sclr_2 FROM sylius_product_attribute_value s0_ WHERE s0_.attribute_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.product_id IN (?, ?, ?, ?, ?, ?, ?) AND s0_.locale_code LIKE ? GROUP BY s0_.attribute_id, s0_.text_value
Parameters:
[ 2 3 4 6 8 11 12 15 17 19 20 21 24 25 26 28 29 31 32 797 798 799 800 801 1131 1132 "fr%" ] |
|
0.79 ms (0.72%) |
1 |
SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
8
]
|
|
0.60 ms (0.55%) |
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, t0.filterable AS filterable_10 FROM sylius_product_attribute t0 WHERE t0.code IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "finition" "taille" "motif" "acier_lame" "materiau_manche" "gamme" "designer" "gravure" "brand" "ressort" "lame" "nombre-de-pieces" "matieres-des-mitres" "REF" "Use" "abeilleetressort" "particularites" "Fourchette" "GRAVURE-PINOT" ] |
|
0.46 ms (0.42%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.metaTitle AS metaTitle_5, t0.metaRobots AS metaRobots_6, t0.ogTitle AS ogTitle_7, t0.ogDescription AS ogDescription_8, t0.ogImage AS ogImage_9, t0.twitterTitle AS twitterTitle_10, t0.twitterDescription AS twitterDescription_11, t0.metaDescription AS metaDescription_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
8
]
|
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 | 32 |
| App\Entity\Product\ProductImage | 23 |
| App\Entity\Taxonomy\TaxonTranslation | 21 |
| App\Entity\Product\ProductTranslation | 21 |
| App\Entity\Product\ProductAttribute | 19 |
| App\Entity\Product\ProductTaxon | 14 |
| App\Entity\Channel\ChannelPricing | 14 |
| App\Entity\Product\Product | 7 |
| App\Entity\Product\ProductVariant | 7 |
| App\Entity\Product\ProductAttributeValue | 6 |
| App\Entity\Locale\Locale | 3 |
| App\Entity\Channel\Channel | 2 |
| App\Entity\Addressing\Zone | 2 |
| App\Entity\Channel\ShopBillingData | 2 |
| App\Entity\Channel\ChannelPriceHistoryConfig | 2 |
| App\Entity\Currency\Currency | 1 |
| App\Entity\Taxation\TaxCategory | 1 |