Query Metrics
60
Database Queries
14
Different statements
111.64 ms
Query time
0
Invalid entities
214
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
26.53 ms (23.76%) |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.attribute_id, s0_.text_value
Parameters:
[ 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 1346 1345 1340 1338 1337 1336 1335 1334 1333 1332 1331 1330 1327 1324 1322 1321 1318 1315 1314 1312 1311 1310 1309 1308 1307 1306 1305 1304 1301 1300 1294 1293 1290 1289 1288 1287 1286 1285 1284 1279 1277 1273 1272 1271 1270 1269 1268 1267 1266 1265 1264 1263 1261 1260 1258 1257 1256 1255 1254 1252 1251 1246 1245 1244 1243 1242 1241 1232 1225 1224 1223 1222 1212 1213 1210 1209 1208 1207 1206 1204 1205 1203 1202 1201 1200 1199 1198 1197 1196 1195 1194 1193 1192 1191 1190 1189 1188 1187 1186 1185 1184 1182 1183 1181 1180 1179 1178 1177 1176 1175 1174 1173 1172 1171 1170 1169 1167 1166 1165 1164 1163 1162 1160 1159 1158 1157 1156 1155 1154 1152 1153 1151 1150 1149 1148 1146 1147 1145 1144 1143 1142 1141 1140 1139 1138 1136 1137 1135 1134 1133 1132 1131 1128 1127 1126 1125 1124 1123 1122 1121 1120 1119 1118 1117 1115 1116 1114 1113 1112 1111 1110 1109 1108 1107 1106 1105 1103 1096 1095 1093 1086 1084 1077 1076 1075 1074 1073 1072 1071 1070 1069 1068 1067 1066 1065 1064 1063 1062 1061 1060 1059 1058 1057 1056 1055 1054 1053 1052 1051 1050 1049 1048 1047 1046 1045 1044 1043 1042 1041 1040 1039 1038 1036 1035 1032 1033 1031 1030 1029 1020 1019 1018 1016 1015 1014 1013 1012 1011 1010 1009 1008 1006 1007 1005 1004 1003 1002 1001 1000 999 997 998 996 995 994 993 992 991 990 989 988 987 986 981 980 979 978 977 976 975 974 973 972 971 969 970 967 968 962 963 961 960 959 958 956 957 953 954 955 951 952 949 950 947 948 944 945 946 942 943 941 940 939 938 937 936 935 934 933 932 931 930 929 928 927 926 925 924 923 922 921 920 919 918 914 912 913 910 911 908 909 906 907 905 903 894 893 892 891 890 889 886 885 884 883 881 882 880 879 878 877 876 875 874 870 855 848 847 846 845 844 843 842 841 840 839 838 837 835 834 833 832 831 830 829 828 827 826 825 824 823 822 821 820 819 818 817 816 815 814 804 803 802 801 800 799 798 797 795 792 791 790 789 788 784 776 773 771 763 762 761 760 759 758 757 756 752 751 750 749 748 746 747 745 744 743 742 741 740 739 738 737 736 735 734 733 732 730 731 729 728 726 727 724 725 722 723 721 720 719 718 717 716 715 714 713 712 711 710 709 708 707 706 705 704 703 702 701 700 699 698 697 696 692 693 691 690 689 688 681 682 680 679 678 677 676 675 674 673 672 671 670 669 666 665 664 663 662 661 660 659 658 657 656 655 653 654 652 651 650 649 648 647 646 645 644 643 642 641 640 639 638 637 635 636 634 632 633 631 630 629 628 627 626 625 624 623 622 621 613 609 608 601 599 ] |
|
21.57 ms (19.32%) |
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_.code_douane AS code_douane_11, s1_.name AS name_12, s1_.slug AS slug_13, s1_.description AS description_14, s1_.meta_keywords AS meta_keywords_15, s1_.meta_description AS meta_description_16, s1_.id AS id_17, s1_.short_description AS short_description_18, s1_.metaTitle AS metaTitle_19, s1_.metaRobots AS metaRobots_20, s1_.ogTitle AS ogTitle_21, s1_.ogDescription AS ogDescription_22, s1_.ogImage AS ogImage_23, s1_.twitterTitle AS twitterTitle_24, s1_.twitterDescription AS twitterDescription_25, s1_.locale AS locale_26, s2_.type AS type_27, s2_.path AS path_28, s2_.id AS id_29, s2_.position AS position_30, s3_.position AS position_31, s3_.id AS id_32, s4_.code AS code_33, s4_.created_at AS created_at_34, s4_.updated_at AS updated_at_35, s4_.position AS position_36, s4_.enabled AS enabled_37, s4_.id AS id_38, s4_.version AS version_39, s4_.on_hold AS on_hold_40, s4_.on_hand AS on_hand_41, s4_.tracked AS tracked_42, s4_.width AS width_43, s4_.height AS height_44, s4_.depth AS depth_45, s4_.weight AS weight_46, s4_.shipping_required AS shipping_required_47, s4_.recurring AS recurring_48, s4_.recurring_times AS recurring_times_49, s4_.recurring_interval AS recurring_interval_50, s5_.price AS price_51, s5_.original_price AS original_price_52, s5_.minimum_price AS minimum_price_53, s5_.lowest_price_before_discount AS lowest_price_before_discount_54, s5_.channel_code AS channel_code_55, s5_.id AS id_56, s6_.code AS code_57, s6_.id AS id_58, s6_.color AS color_59, s6_.iconName AS iconName_60, s6_.updatedAt AS updatedAt_61, s0_.main_taxon_id AS main_taxon_id_62, s0_.product_type_id AS product_type_id_63, s1_.translatable_id AS translatable_id_64, s2_.owner_id AS owner_id_65, s3_.product_id AS product_id_66, s3_.taxon_id AS taxon_id_67, s4_.product_id AS product_id_68, s4_.tax_category_id AS tax_category_id_69, s4_.shipping_category_id AS shipping_category_id_70, s5_.product_variant_id AS product_variant_id_71, s6_.option_id AS option_id_72 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:
[ 1269 1268 1267 1266 1265 1264 1263 1261 1260 ] |
|
18.51 ms (16.58%) |
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:
[ 1346 1345 1340 1338 1337 1336 1335 1334 1333 1332 1331 1330 1327 1324 1322 1321 1318 1315 1314 1312 1311 1310 1309 1308 1307 1306 1305 1304 1301 1300 1294 1293 1290 1289 1288 1287 1286 1285 1284 1279 1277 1273 1272 1271 1270 1269 1268 1267 1266 1265 1264 1263 1261 1260 1258 1257 1256 1255 1254 1252 1251 1246 1245 1244 1243 1242 1241 1232 1225 1224 1223 1222 1212 1213 1210 1209 1208 1207 1206 1204 1205 1203 1202 1201 1200 1199 1198 1197 1196 1195 1194 1193 1192 1191 1190 1189 1188 1187 1186 1185 1184 1182 1183 1181 1180 1179 1178 1177 1176 1175 1174 1173 1172 1171 1170 1169 1167 1166 1165 1164 1163 1162 1160 1159 1158 1157 1156 1155 1154 1152 1153 1151 1150 1149 1148 1146 1147 1145 1144 1143 1142 1141 1140 1139 1138 1136 1137 1135 1134 1133 1132 1131 1128 1127 1126 1125 1124 1123 1122 1121 1120 1119 1118 1117 1115 1116 1114 1113 1112 1111 1110 1109 1108 1107 1106 1105 1103 1096 1095 1093 1086 1084 1077 1076 1075 1074 1073 1072 1071 1070 1069 1068 1067 1066 1065 1064 1063 1062 1061 1060 1059 1058 1057 1056 1055 1054 1053 1052 1051 1050 1049 1048 1047 1046 1045 1044 1043 1042 1041 1040 1039 1038 1036 1035 1032 1033 1031 1030 1029 1020 1019 1018 1016 1015 1014 1013 1012 1011 1010 1009 1008 1006 1007 1005 1004 1003 1002 1001 1000 999 997 998 996 995 994 993 992 991 990 989 988 987 986 981 980 979 978 977 976 975 974 973 972 971 969 970 967 968 962 963 961 960 959 958 956 957 953 954 955 951 952 949 950 947 948 944 945 946 942 943 941 940 939 938 937 936 935 934 933 932 931 930 929 928 927 926 925 924 923 922 921 920 919 918 914 912 913 910 911 908 909 906 907 905 903 894 893 892 891 890 889 886 885 884 883 881 882 880 879 878 877 876 875 874 870 855 848 847 846 845 844 843 842 841 840 839 838 837 835 834 833 832 831 830 829 828 827 826 825 824 823 822 821 820 819 818 817 816 815 814 804 803 802 801 800 799 798 797 795 792 791 790 789 788 784 776 773 771 763 762 761 760 759 758 757 756 752 751 750 749 748 746 747 745 744 743 742 741 740 739 738 737 736 735 734 733 732 730 731 729 728 726 727 724 725 722 723 721 720 719 718 717 716 715 714 713 712 711 710 709 708 707 706 705 704 703 702 701 700 699 698 697 696 692 693 691 690 689 688 681 682 680 679 678 677 676 675 674 673 672 671 670 669 666 665 664 663 662 661 660 659 658 657 656 655 653 654 652 651 650 649 648 647 646 645 644 643 642 641 640 639 638 637 635 636 634 632 633 631 630 629 628 627 626 625 624 623 622 621 613 609 608 601 599 ] |
|
13.22 ms (11.84%) |
25 |
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:
[ 8 "en_US" ] |
|
8.11 ms (7.26%) |
8 |
SELECT t0.value AS value_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_option_value_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 167 "en_US" ] |
|
5.87 ms (5.26%) |
12 |
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"
]
|
|
4.47 ms (4.01%) |
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 WHERE s0_.enabled = 1 AND s1_.code = ? GROUP BY s0_.id ORDER BY s0_.created_at DESC
Parameters:
[
"WEB-EU"
]
|
|
4.03 ms (3.61%) |
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" "matiere" "Nombre" 1346 1345 1340 1338 1337 1336 1335 1334 1333 1332 1331 1330 1327 1324 1322 1321 1318 1315 1314 1312 1311 1310 1309 1308 1307 1306 1305 1304 1301 1300 1294 1293 1290 1289 1288 1287 1286 1285 1284 1279 1277 1273 1272 1271 1270 1269 1268 1267 1266 1265 1264 1263 1261 1260 1258 1257 1256 1255 1254 1252 1251 1246 1245 1244 1243 1242 1241 1232 1225 1224 1223 1222 1212 1213 1210 1209 1208 1207 1206 1204 1205 1203 1202 1201 1200 1199 1198 1197 1196 1195 1194 1193 1192 1191 1190 1189 1188 1187 1186 1185 1184 1182 1183 1181 1180 1179 1178 1177 1176 1175 1174 1173 1172 1171 1170 1169 1167 1166 1165 1164 1163 1162 1160 1159 1158 1157 1156 1155 1154 1152 1153 1151 1150 1149 1148 1146 1147 1145 1144 1143 1142 1141 1140 1139 1138 1136 1137 1135 1134 1133 1132 1131 1128 1127 1126 1125 1124 1123 1122 1121 1120 1119 1118 1117 1115 1116 1114 1113 1112 1111 1110 1109 1108 1107 1106 1105 1103 1096 1095 1093 1086 1084 1077 1076 1075 1074 1073 1072 1071 1070 1069 1068 1067 1066 1065 1064 1063 1062 1061 1060 1059 1058 1057 1056 1055 1054 1053 1052 1051 1050 1049 1048 1047 1046 1045 1044 1043 1042 1041 1040 1039 1038 1036 1035 1032 1033 1031 1030 1029 1020 1019 1018 1016 1015 1014 1013 1012 1011 1010 1009 1008 1006 1007 1005 1004 1003 1002 1001 1000 999 997 998 996 995 994 993 992 991 990 989 988 987 986 981 980 979 978 977 976 975 974 973 972 971 969 970 967 968 962 963 961 960 959 958 956 957 953 954 955 951 952 949 950 947 948 944 945 946 942 943 941 940 939 938 937 936 935 934 933 932 931 930 929 928 927 926 925 924 923 922 921 920 919 918 914 912 913 910 911 908 909 906 907 905 903 894 893 892 891 890 889 886 885 884 883 881 882 880 879 878 877 876 875 874 870 855 848 847 846 845 844 843 842 841 840 839 838 837 835 834 833 832 831 830 829 828 827 826 825 824 823 822 821 820 819 818 817 816 815 814 804 803 802 801 800 799 798 797 795 792 791 790 789 788 784 776 773 771 763 762 761 760 759 758 757 756 752 751 750 749 748 746 747 745 744 743 742 741 740 739 738 737 736 735 734 733 732 730 731 729 728 726 727 724 725 722 723 721 720 719 718 717 716 715 714 713 712 711 710 709 708 707 706 705 704 703 702 701 700 699 698 697 696 692 693 691 690 689 688 681 682 680 679 678 677 676 675 674 673 672 671 670 669 666 665 664 663 662 661 660 659 658 657 656 655 653 654 652 651 650 649 648 647 646 645 644 643 642 641 640 639 638 637 635 636 634 632 633 631 630 629 628 627 626 625 624 623 622 621 613 609 608 601 599 ] |
|
3.10 ms (2.78%) |
5 |
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:
[
8
]
|
|
1.88 ms (1.68%) |
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 ] |
|
1.19 ms (1.06%) |
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
]
|
|
1.12 ms (1.00%) |
1 |
SELECT t0.code AS code_1, t0.id AS id_2, t0.color AS color_3, t0.iconName AS iconName_4, t0.updatedAt AS updatedAt_5, t0.option_id AS option_id_6 FROM sylius_product_option_value t0 WHERE t0.code IN (?, ?, ?, ?, ?, ?)
Parameters:
[ "acier" "cuivre" "2" "6" "taille-11-cm" "taille-12-cm" ] |
|
1.03 ms (0.92%) |
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" "forme_manche" "acier_lame" "materiau_lame" "materiau_manche" "materiau_mitres" "type" "gamme" "designer" "coffret" "composantes" "gravure" "resistance_eau" "brand" "nombre-de-mitres" "ressort" "lame" "nombre-de-pieces" "usage" "design" "matieres-des-mitres" "REF" "Use" "Coffrets" ] |
|
1.01 ms (0.91%) |
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"
]
|
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 | 32 |
| App\Entity\Product\ProductTranslation | 27 |
| App\Entity\Product\ProductAttribute | 26 |
| App\Entity\Taxonomy\TaxonTranslation | 19 |
| App\Entity\Product\ProductTaxon | 18 |
| App\Entity\Channel\ChannelPricing | 18 |
| App\Entity\Product\Product | 9 |
| App\Entity\Product\ProductVariant | 9 |
| App\Entity\Product\ProductOptionValue | 6 |
| App\Entity\Product\ProductOptionValueTranslation | 6 |
| App\Entity\Locale\Locale | 3 |
| App\Entity\Product\ProductOption | 3 |
| App\Entity\Channel\Channel | 1 |
| App\Entity\Addressing\Zone | 1 |
| App\Entity\Channel\ShopBillingData | 1 |
| App\Entity\Channel\ChannelPriceHistoryConfig | 1 |
| App\Entity\Currency\Currency | 1 |
| App\Entity\Taxation\TaxCategory | 1 |