Query Metrics
24
Database Queries
18
Different statements
45.39 ms
Query time
0
Invalid entities
316
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.28 ms |
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.name AS name_3, t0.title AS title_4, t0.specification AS specification_5, t0.description AS description_6, t0.visible AS visible_7, t0.source_id AS source_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.remote_category_id AS remote_category_id_10 FROM product t0 WHERE t0.id = ?
Parameters:
[
"16"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.source_id AS source_id_3, t0.category_id AS category_id_4 FROM remote_category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.depth AS depth_7, t0.sort_path AS sort_path_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = ?
Parameters:
[
7
]
|
||||||||||||||||||||||||||||||||
| 4 | 4.56 ms |
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.visible AS visible_3, a0_.position AS position_4, a0_.depth AS depth_5, a0_.sort_path AS sort_path_6, a0_.parent_id AS parent_id_7 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_variant_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id ORDER BY a0_.sort_path ASC
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 5 | 2.42 ms |
SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.id ASC
Parameters:
[ 16 1 ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.37 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 7 | 3.04 ms |
SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? AND p3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.id ASC
Parameters:
[ 16 1 915 916 917 924 925 926 927 928 929 930 933 934 935 936 937 939 940 941 942 943 944 945 946 947 948 950 951 952 953 954 955 956 960 961 965 966 967 968 984 1011 1023 1024 1025 1026 1028 1046 1050 1051 1052 1060 1071 1073 1075 1102 1103 1104 1105 1106 1108 1111 1112 1113 1114 1125 1131 1132 1164 1220 1228 918 919 920 921 922 931 938 949 957 959 958 981 982 983 985 986 1012 1013 1014 1015 1018 1019 1020 1030 1031 1032 1033 1034 1058 1059 1083 1084 1100 1168 1166 1167 1184 1185 1186 1201 1202 1203 1221 932 923 1179 1234 1235 1236 9685 9686 9687 12793 16227 16228 16229 16230 14491 14492 14493 14494 9680 9681 9682 9683 9684 16231 16232 16233 9863 9864 9865 9866 9867 9868 12198 12199 12200 12201 12202 14489 14718 14719 14720 14721 14722 962 963 964 969 970 971 972 973 974 975 976 977 978 979 980 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1021 1022 1027 1029 1037 1038 1039 1040 1045 1047 1048 1049 1053 1054 1055 1056 1057 1061 1062 1063 1064 1065 1066 1069 1070 1072 1074 1076 1077 1078 1079 1080 1081 1082 1085 1086 1087 1088 1089 1090 1093 1094 1095 1096 1097 1098 1099 1101 1107 1109 1110 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1126 1127 1128 1129 1130 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1149 1150 1151 1152 1157 1158 1159 1165 1173 1174 1175 1176 1177 1178 1182 1183 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1222 1223 1224 1225 1226 1227 1229 1230 1231 1232 1233 9869 9870 12203 12204 12205 12786 12787 12788 12789 12790 12791 12792 14487 14488 14490 14723 14724 14725 16124 16125 16126 16127 16128 16129 16130 16131 1006 1007 1008 1009 1010 1016 1017 1035 1036 1041 1042 1043 1044 1067 1068 1091 1092 1146 1147 1148 1153 1154 1155 1156 1160 1161 1162 1163 1169 1170 1171 1172 1180 1181 1187 1188 1189 1204 1205 1237 16226 ]
|
||||||||||||||||||||||||||||||||
| 8 | 2.35 ms |
SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.value ASC
Parameters:
[ 16 10 ]
|
||||||||||||||||||||||||||||||||
| 9 | 0.42 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 10 | 2.72 ms |
SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? AND p3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.value ASC
Parameters:
[ 16 10 915 916 917 924 925 926 927 928 929 930 933 934 935 936 937 939 940 941 942 943 944 945 946 947 948 950 951 952 953 954 955 956 960 961 965 966 967 968 984 1011 1023 1024 1025 1026 1028 1046 1050 1051 1052 1060 1071 1073 1075 1102 1103 1104 1105 1106 1108 1111 1112 1113 1114 1125 1131 1132 1164 1220 1228 918 919 920 921 922 931 938 949 957 959 958 981 982 983 985 986 1012 1013 1014 1015 1018 1019 1020 1030 1031 1032 1033 1034 1058 1059 1083 1084 1100 1168 1166 1167 1184 1185 1186 1201 1202 1203 1221 932 923 1179 1234 1235 1236 9685 9686 9687 12793 16227 16228 16229 16230 14491 14492 14493 14494 9680 9681 9682 9683 9684 16231 16232 16233 9863 9864 9865 9866 9867 9868 12198 12199 12200 12201 12202 14489 14718 14719 14720 14721 14722 962 963 964 969 970 971 972 973 974 975 976 977 978 979 980 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1021 1022 1027 1029 1037 1038 1039 1040 1045 1047 1048 1049 1053 1054 1055 1056 1057 1061 1062 1063 1064 1065 1066 1069 1070 1072 1074 1076 1077 1078 1079 1080 1081 1082 1085 1086 1087 1088 1089 1090 1093 1094 1095 1096 1097 1098 1099 1101 1107 1109 1110 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1126 1127 1128 1129 1130 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1149 1150 1151 1152 1157 1158 1159 1165 1173 1174 1175 1176 1177 1178 1182 1183 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1222 1223 1224 1225 1226 1227 1229 1230 1231 1232 1233 9869 9870 12203 12204 12205 12786 12787 12788 12789 12790 12791 12792 14487 14488 14490 14723 14724 14725 16124 16125 16126 16127 16128 16129 16130 16131 1006 1007 1008 1009 1010 1016 1017 1035 1036 1041 1042 1043 1044 1067 1068 1091 1092 1146 1147 1148 1153 1154 1155 1156 1160 1161 1162 1163 1169 1170 1171 1172 1180 1181 1187 1188 1189 1204 1205 1237 16226 ]
|
||||||||||||||||||||||||||||||||
| 11 | 0.45 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 12 | 0.33 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 13 | 15.23 ms |
SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC
Parameters:
[ 16 915 916 917 924 925 926 927 928 929 930 933 934 935 936 937 939 940 941 942 943 944 945 946 947 948 950 951 952 953 954 955 956 960 961 965 966 967 968 984 1011 1023 1024 1025 1026 1028 1046 1050 1051 1052 1060 1071 1073 1075 1102 1103 1104 1105 1106 1108 1111 1112 1113 1114 1125 1131 1132 1164 1220 1228 918 919 920 921 922 931 938 949 957 959 958 981 982 983 985 986 1012 1013 1014 1015 1018 1019 1020 1030 1031 1032 1033 1034 1058 1059 1083 1084 1100 1168 1166 1167 1184 1185 1186 1201 1202 1203 1221 932 923 1179 1234 1235 1236 9685 9686 9687 12793 16227 16228 16229 16230 14491 14492 14493 14494 9680 9681 9682 9683 9684 16231 16232 16233 9863 9864 9865 9866 9867 9868 12198 12199 12200 12201 12202 14489 14718 14719 14720 14721 14722 962 963 964 969 970 971 972 973 974 975 976 977 978 979 980 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1021 1022 1027 1029 1037 1038 1039 1040 1045 1047 1048 1049 1053 1054 1055 1056 1057 1061 1062 1063 1064 1065 1066 1069 1070 1072 1074 1076 1077 1078 1079 1080 1081 1082 1085 1086 1087 1088 1089 1090 1093 1094 1095 1096 1097 1098 1099 1101 1107 1109 1110 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1126 1127 1128 1129 1130 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1149 1150 1151 1152 1157 1158 1159 1165 1173 1174 1175 1176 1177 1178 1182 1183 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1222 1223 1224 1225 1226 1227 1229 1230 1231 1232 1233 9869 9870 12203 12204 12205 12786 12787 12788 12789 12790 12791 12792 14487 14488 14490 14723 14724 14725 16124 16125 16126 16127 16128 16129 16130 16131 1006 1007 1008 1009 1010 1016 1017 1035 1036 1041 1042 1043 1044 1067 1068 1091 1092 1146 1147 1148 1153 1154 1155 1156 1160 1161 1162 1163 1169 1170 1171 1172 1180 1181 1187 1188 1189 1204 1205 1237 16226 ]
|
||||||||||||||||||||||||||||||||
| 14 | 1.90 ms |
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.visible AS visible_3, a0_.position AS position_4, a0_.depth AS depth_5, a0_.sort_path AS sort_path_6, a1_.id AS id_7, a1_.value AS value_8, a1_.value_float AS value_float_9, a0_.parent_id AS parent_id_10, a1_.attribute_id AS attribute_id_11 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id, a0_.code, a0_.name, a0_.visible, a0_.position, a0_.depth, a0_.sort_path, a0_.parent_id, a1_.id, a1_.value, a1_.value_float, a1_.attribute_id ORDER BY a0_.sort_path ASC
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 15 | 0.56 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 16 | 2.17 ms |
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 16 915 916 917 924 925 926 927 928 929 930 933 934 935 936 937 939 940 941 942 943 944 945 946 947 948 950 951 952 953 954 955 956 960 961 965 966 967 968 984 1011 1023 1024 1025 1026 1028 1046 1050 1051 1052 1060 1071 1073 1075 1102 1103 1104 1105 1106 1108 1111 1112 1113 1114 1125 1131 1132 1164 1220 1228 918 919 920 921 922 931 938 949 957 959 958 981 982 983 985 986 1012 1013 1014 1015 1018 1019 1020 1030 1031 1032 1033 1034 1058 1059 1083 1084 1100 1168 1166 1167 1184 1185 1186 1201 1202 1203 1221 932 923 1179 1234 1235 1236 9685 9686 9687 12793 16227 16228 16229 16230 14491 14492 14493 14494 9680 9681 9682 9683 9684 16231 16232 16233 9863 9864 9865 9866 9867 9868 12198 12199 12200 12201 12202 14489 14718 14719 14720 14721 14722 962 963 964 969 970 971 972 973 974 975 976 977 978 979 980 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1021 1022 1027 1029 1037 1038 1039 1040 1045 1047 1048 1049 1053 1054 1055 1056 1057 1061 1062 1063 1064 1065 1066 1069 1070 1072 1074 1076 1077 1078 1079 1080 1081 1082 1085 1086 1087 1088 1089 1090 1093 1094 1095 1096 1097 1098 1099 1101 1107 1109 1110 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1126 1127 1128 1129 1130 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1149 1150 1151 1152 1157 1158 1159 1165 1173 1174 1175 1176 1177 1178 1182 1183 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1222 1223 1224 1225 1226 1227 1229 1230 1231 1232 1233 9869 9870 12203 12204 12205 12786 12787 12788 12789 12790 12791 12792 14487 14488 14490 14723 14724 14725 16124 16125 16126 16127 16128 16129 16130 16131 1006 1007 1008 1009 1010 1016 1017 1035 1036 1041 1042 1043 1044 1067 1068 1091 1092 1146 1147 1148 1153 1154 1155 1156 1160 1161 1162 1163 1169 1170 1171 1172 1180 1181 1187 1188 1189 1204 1205 1237 16226 ]
|
||||||||||||||||||||||||||||||||
| 17 | 0.55 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visible AS visible_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.position AS position_5, c0_.depth AS depth_6, c0_.sort_path AS sort_path_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.visible = true ORDER BY c0_.sort_path ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||
| 18 | 0.98 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.owner_id AS owner_id_4, t0.shipping_method_id AS shipping_method_id_5, t0.payment_method_id AS payment_method_id_6 FROM cart t0 WHERE t0.id = ?
Parameters:
[
151
]
|
||||||||||||||||||||||||||||||||
| 19 | 2.57 ms |
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c1_.id AS id_3, c1_.quantity AS quantity_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, p2_.id AS id_7, p2_.ean AS ean_8, p2_.price AS price_9, p2_.stock AS stock_10, p2_.visible AS visible_11, p3_.id AS id_12, p3_.remote_id AS remote_id_13, p3_.name AS name_14, p3_.title AS title_15, p3_.specification AS specification_16, p3_.description AS description_17, p3_.visible AS visible_18, p4_.id AS id_19, a5_.id AS id_20, a5_.value AS value_21, a5_.value_float AS value_float_22, a6_.id AS id_23, a6_.code AS code_24, a6_.name AS name_25, a6_.visible AS visible_26, a6_.position AS position_27, a6_.depth AS depth_28, a6_.sort_path AS sort_path_29, p7_.id AS id_30, p7_.original_filename AS original_filename_31, p7_.filename AS filename_32, p7_.mime_type AS mime_type_33, p7_.size AS size_34, p7_.path AS path_35, p7_.created_at AS created_at_36, p7_.updated_at AS updated_at_37, c0_.owner_id AS owner_id_38, c0_.shipping_method_id AS shipping_method_id_39, c0_.payment_method_id AS payment_method_id_40, c1_.cart_id AS cart_id_41, c1_.product_variant_id AS product_variant_id_42, c1_.project_file_id AS project_file_id_43, p2_.product_id AS product_id_44, p3_.source_id AS source_id_45, p3_.manufacturer_id AS manufacturer_id_46, p3_.remote_category_id AS remote_category_id_47, p4_.variant_id AS variant_id_48, p4_.attribute_value_id AS attribute_value_id_49, a5_.attribute_id AS attribute_id_50, a6_.parent_id AS parent_id_51, p7_.user_id AS user_id_52 FROM cart c0_ LEFT JOIN cart_product_variant c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id LEFT JOIN product_variant_attribute_value p4_ ON p2_.id = p4_.variant_id LEFT JOIN attribute_value a5_ ON p4_.attribute_value_id = a5_.id LEFT JOIN attribute a6_ ON a5_.attribute_id = a6_.id LEFT JOIN project_file p7_ ON c1_.project_file_id = p7_.id WHERE c0_.id = ?
Parameters:
[
151
]
|
||||||||||||||||||||||||||||||||
| 20 | 0.73 ms |
SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.attachment_image_id AS attachment_image_id_3 FROM product_attachment_image t0 WHERE t0.product_id = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||
| 21 | 0.64 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.filename AS filename_4, t0.hash AS hash_5, t0.attachment_id AS attachment_id_6 FROM attachment_image t0 WHERE t0.id = ?
Parameters:
[
31
]
|
||||||||||||||||||||||||||||||||
| 22 | 0.47 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.visible AS visible_4, t0.position AS position_5, t0.depth AS depth_6, t0.sort_path AS sort_path_7, t0.parent_id AS parent_id_8 FROM attachment t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 23 | 0.22 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.filename AS filename_4, t0.hash AS hash_5, t0.attachment_id AS attachment_id_6 FROM attachment_image t0 WHERE t0.id = ?
Parameters:
[
32
]
|
||||||||||||||||||||||||||||||||
| 24 | 0.23 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.visible AS visible_4, t0.position AS position_5, t0.depth AS depth_6, t0.sort_path AS sort_path_7, t0.parent_id AS parent_id_8 FROM attachment t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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\Image | 215 |
| App\Entity\AttributeValue | 66 |
| App\Entity\Category | 15 |
| App\Entity\Attribute | 9 |
| App\Entity\ProductAttachmentImage | 2 |
| App\Entity\AttachmentImage | 2 |
| App\Entity\Attachment | 2 |
| App\Entity\Product | 1 |
| App\Entity\Source | 1 |
| App\Entity\Manufacturer | 1 |
| App\Entity\RemoteCategory | 1 |
| App\Entity\Cart | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Product | No errors. |
| App\Entity\Source | No errors. |
| App\Entity\Manufacturer | No errors. |
| App\Entity\RemoteCategory | No errors. |
| App\Entity\ProductAttachmentImage | No errors. |
| App\Entity\ProductVariant | No errors. |
| App\Entity\ProductAttributeValue | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Attribute | No errors. |
| App\Entity\AttributeValue | No errors. |
| App\Entity\ProductVariantAttributeValue | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\ProductVariantImage | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ShippingMethod | No errors. |
| App\Entity\PaymentMethod | No errors. |
| App\Entity\CartProductVariant | No errors. |
| App\Entity\ProjectFile | No errors. |
| App\Entity\AttachmentImage | No errors. |
| App\Entity\Attachment | No errors. |