Query Metrics
24
Database Queries
18
Different statements
25.45 ms
Query time
0
Invalid entities
248
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.20 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.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.source_id AS source_id_10, t0.manufacturer_id AS manufacturer_id_11, t0.remote_category_id AS remote_category_id_12 FROM product t0 WHERE t0.id = ?
Parameters:
[
"61"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.43 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:
[
2
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.37 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:
[
8
]
|
||||||||||||||||||||||||||||||||
| 4 | 3.69 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:
[
61
]
|
||||||||||||||||||||||||||||||||
| 5 | 1.99 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:
[ 61 1 ]
|
||||||||||||||||||||||||||||||||
| 6 | 0.34 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
61
]
|
||||||||||||||||||||||||||||||||
| 7 | 2.24 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:
[ 61 1 4081 4089 4090 4091 4092 4093 4094 4095 4097 4102 4103 4104 4105 4106 4107 4108 4109 4110 4111 4112 4113 4116 4117 4118 4119 4120 4121 4122 4123 4124 4125 4126 4127 4130 4131 4132 4133 4134 4136 4143 4144 4145 4146 4147 4148 4150 4151 4157 4158 4159 4160 4161 4162 4163 4164 4165 4166 4167 4168 4169 4171 4172 4173 4174 4175 4177 4178 4179 4180 4181 4182 4183 4184 4185 4186 4187 4194 4200 4201 4202 4203 4204 4205 4206 4207 4208 4209 4210 4211 4213 4214 4215 4216 4218 4219 4220 4221 4222 4223 4224 4230 4231 4232 4233 4234 4235 4236 4237 4238 4239 4240 4241 4243 4244 4245 4246 4247 4248 4249 4250 4251 4252 9708 9709 12833 12834 12835 15635 15636 4082 4083 4098 4099 4100 4101 4114 4115 4135 4137 4138 4139 4140 4141 4142 4149 4152 4153 4154 4155 4156 4073 4074 4075 4076 4077 4078 4079 4080 4096 4170 4176 4188 4189 4190 4191 4192 4193 4195 4196 4197 4198 4199 4212 4217 4253 4254 9710 4084 4085 4086 4087 4088 4128 4129 4225 4226 4227 4228 4229 4242 9699 9700 9701 9702 9703 9704 9705 9706 9707 9913 9914 9915 9916 9917 9918 12774 12775 12776 12777 12778 12779 12830 12831 12832 14629 14630 14631 14632 14633 14634 14753 14754 14755 14756 14757 14758 14848 14849 14850 14851 15631 15632 15633 15634 16288 16289 16290 16291 16292 16293 ]
|
||||||||||||||||||||||||||||||||
| 8 | 1.90 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:
[ 61 10 ]
|
||||||||||||||||||||||||||||||||
| 9 | 0.29 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
61
]
|
||||||||||||||||||||||||||||||||
| 10 | 1.73 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:
[ 61 10 4081 4089 4090 4091 4092 4093 4094 4095 4097 4102 4103 4104 4105 4106 4107 4108 4109 4110 4111 4112 4113 4116 4117 4118 4119 4120 4121 4122 4123 4124 4125 4126 4127 4130 4131 4132 4133 4134 4136 4143 4144 4145 4146 4147 4148 4150 4151 4157 4158 4159 4160 4161 4162 4163 4164 4165 4166 4167 4168 4169 4171 4172 4173 4174 4175 4177 4178 4179 4180 4181 4182 4183 4184 4185 4186 4187 4194 4200 4201 4202 4203 4204 4205 4206 4207 4208 4209 4210 4211 4213 4214 4215 4216 4218 4219 4220 4221 4222 4223 4224 4230 4231 4232 4233 4234 4235 4236 4237 4238 4239 4240 4241 4243 4244 4245 4246 4247 4248 4249 4250 4251 4252 9708 9709 12833 12834 12835 15635 15636 4082 4083 4098 4099 4100 4101 4114 4115 4135 4137 4138 4139 4140 4141 4142 4149 4152 4153 4154 4155 4156 4073 4074 4075 4076 4077 4078 4079 4080 4096 4170 4176 4188 4189 4190 4191 4192 4193 4195 4196 4197 4198 4199 4212 4217 4253 4254 9710 4084 4085 4086 4087 4088 4128 4129 4225 4226 4227 4228 4229 4242 9699 9700 9701 9702 9703 9704 9705 9706 9707 9913 9914 9915 9916 9917 9918 12774 12775 12776 12777 12778 12779 12830 12831 12832 14629 14630 14631 14632 14633 14634 14753 14754 14755 14756 14757 14758 14848 14849 14850 14851 15631 15632 15633 15634 16288 16289 16290 16291 16292 16293 ]
|
||||||||||||||||||||||||||||||||
| 11 | 0.31 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
61
]
|
||||||||||||||||||||||||||||||||
| 12 | 0.27 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
61
]
|
||||||||||||||||||||||||||||||||
| 13 | 2.86 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:
[ 61 4081 4089 4090 4091 4092 4093 4094 4095 4097 4102 4103 4104 4105 4106 4107 4108 4109 4110 4111 4112 4113 4116 4117 4118 4119 4120 4121 4122 4123 4124 4125 4126 4127 4130 4131 4132 4133 4134 4136 4143 4144 4145 4146 4147 4148 4150 4151 4157 4158 4159 4160 4161 4162 4163 4164 4165 4166 4167 4168 4169 4171 4172 4173 4174 4175 4177 4178 4179 4180 4181 4182 4183 4184 4185 4186 4187 4194 4200 4201 4202 4203 4204 4205 4206 4207 4208 4209 4210 4211 4213 4214 4215 4216 4218 4219 4220 4221 4222 4223 4224 4230 4231 4232 4233 4234 4235 4236 4237 4238 4239 4240 4241 4243 4244 4245 4246 4247 4248 4249 4250 4251 4252 9708 9709 12833 12834 12835 15635 15636 4082 4083 4098 4099 4100 4101 4114 4115 4135 4137 4138 4139 4140 4141 4142 4149 4152 4153 4154 4155 4156 4073 4074 4075 4076 4077 4078 4079 4080 4096 4170 4176 4188 4189 4190 4191 4192 4193 4195 4196 4197 4198 4199 4212 4217 4253 4254 9710 4084 4085 4086 4087 4088 4128 4129 4225 4226 4227 4228 4229 4242 9699 9700 9701 9702 9703 9704 9705 9706 9707 9913 9914 9915 9916 9917 9918 12774 12775 12776 12777 12778 12779 12830 12831 12832 14629 14630 14631 14632 14633 14634 14753 14754 14755 14756 14757 14758 14848 14849 14850 14851 15631 15632 15633 15634 16288 16289 16290 16291 16292 16293 ]
|
||||||||||||||||||||||||||||||||
| 14 | 0.99 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:
[
61
]
|
||||||||||||||||||||||||||||||||
| 15 | 0.30 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
Parameters:
[
61
]
|
||||||||||||||||||||||||||||||||
| 16 | 1.08 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:
[ 61 4081 4089 4090 4091 4092 4093 4094 4095 4097 4102 4103 4104 4105 4106 4107 4108 4109 4110 4111 4112 4113 4116 4117 4118 4119 4120 4121 4122 4123 4124 4125 4126 4127 4130 4131 4132 4133 4134 4136 4143 4144 4145 4146 4147 4148 4150 4151 4157 4158 4159 4160 4161 4162 4163 4164 4165 4166 4167 4168 4169 4171 4172 4173 4174 4175 4177 4178 4179 4180 4181 4182 4183 4184 4185 4186 4187 4194 4200 4201 4202 4203 4204 4205 4206 4207 4208 4209 4210 4211 4213 4214 4215 4216 4218 4219 4220 4221 4222 4223 4224 4230 4231 4232 4233 4234 4235 4236 4237 4238 4239 4240 4241 4243 4244 4245 4246 4247 4248 4249 4250 4251 4252 9708 9709 12833 12834 12835 15635 15636 4082 4083 4098 4099 4100 4101 4114 4115 4135 4137 4138 4139 4140 4141 4142 4149 4152 4153 4154 4155 4156 4073 4074 4075 4076 4077 4078 4079 4080 4096 4170 4176 4188 4189 4190 4191 4192 4193 4195 4196 4197 4198 4199 4212 4217 4253 4254 9710 4084 4085 4086 4087 4088 4128 4129 4225 4226 4227 4228 4229 4242 9699 9700 9701 9702 9703 9704 9705 9706 9707 9913 9914 9915 9916 9917 9918 12774 12775 12776 12777 12778 12779 12830 12831 12832 14629 14630 14631 14632 14633 14634 14753 14754 14755 14756 14757 14758 14848 14849 14850 14851 15631 15632 15633 15634 16288 16289 16290 16291 16292 16293 ]
|
||||||||||||||||||||||||||||||||
| 17 | 0.25 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.49 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, t0.applied_discount_code_id AS applied_discount_code_id_7 FROM cart t0 WHERE t0.id = ?
Parameters:
[
522
]
|
||||||||||||||||||||||||||||||||
| 19 | 2.91 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, p3_.created_at AS created_at_19, p3_.updated_at AS updated_at_20, r4_.id AS id_21, r4_.name AS name_22, c5_.id AS id_23, c5_.name AS name_24, c5_.visible AS visible_25, c5_.created_at AS created_at_26, c5_.updated_at AS updated_at_27, c5_.position AS position_28, c5_.depth AS depth_29, c5_.sort_path AS sort_path_30, p6_.id AS id_31, a7_.id AS id_32, a7_.value AS value_33, a7_.value_float AS value_float_34, a8_.id AS id_35, a8_.code AS code_36, a8_.name AS name_37, a8_.visible AS visible_38, a8_.position AS position_39, a8_.depth AS depth_40, a8_.sort_path AS sort_path_41, p9_.id AS id_42, p9_.original_filename AS original_filename_43, p9_.filename AS filename_44, p9_.mime_type AS mime_type_45, p9_.size AS size_46, p9_.path AS path_47, p9_.created_at AS created_at_48, p9_.updated_at AS updated_at_49, d10_.id AS id_50, d10_.code AS code_51, d10_.type AS type_52, d10_.value AS value_53, d10_.max_discount_amount AS max_discount_amount_54, d10_.active AS active_55, d10_.valid_from AS valid_from_56, d10_.valid_to AS valid_to_57, d10_.max_uses_total AS max_uses_total_58, d10_.max_uses_per_user AS max_uses_per_user_59, d10_.min_cart_value AS min_cart_value_60, d10_.min_cart_items AS min_cart_items_61, d10_.created_at AS created_at_62, d10_.updated_at AS updated_at_63, c0_.owner_id AS owner_id_64, c0_.shipping_method_id AS shipping_method_id_65, c0_.payment_method_id AS payment_method_id_66, c0_.applied_discount_code_id AS applied_discount_code_id_67, c1_.cart_id AS cart_id_68, c1_.product_variant_id AS product_variant_id_69, c1_.project_file_id AS project_file_id_70, p2_.product_id AS product_id_71, p3_.source_id AS source_id_72, p3_.manufacturer_id AS manufacturer_id_73, p3_.remote_category_id AS remote_category_id_74, r4_.source_id AS source_id_75, r4_.category_id AS category_id_76, c5_.parent_id AS parent_id_77, p6_.variant_id AS variant_id_78, p6_.attribute_value_id AS attribute_value_id_79, a7_.attribute_id AS attribute_id_80, a8_.parent_id AS parent_id_81, p9_.user_id AS user_id_82, d10_.restricted_to_user_id AS restricted_to_user_id_83 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 remote_category r4_ ON p3_.remote_category_id = r4_.id LEFT JOIN category c5_ ON r4_.category_id = c5_.id LEFT JOIN product_variant_attribute_value p6_ ON p2_.id = p6_.variant_id LEFT JOIN attribute_value a7_ ON p6_.attribute_value_id = a7_.id LEFT JOIN attribute a8_ ON a7_.attribute_id = a8_.id LEFT JOIN project_file p9_ ON c1_.project_file_id = p9_.id LEFT JOIN discount_code d10_ ON c0_.applied_discount_code_id = d10_.id WHERE c0_.id = ? ORDER BY c1_.id ASC
Parameters:
[
522
]
|
||||||||||||||||||||||||||||||||
| 20 | 0.52 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:
[
61
]
|
||||||||||||||||||||||||||||||||
| 21 | 0.51 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:
[
121
]
|
||||||||||||||||||||||||||||||||
| 22 | 0.40 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.19 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:
[
122
]
|
||||||||||||||||||||||||||||||||
| 24 | 0.18 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 | 169 |
| App\Entity\AttributeValue | 52 |
| App\Entity\Category | 10 |
| App\Entity\Attribute | 6 |
| 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\DiscountCode | No errors. |
| App\Entity\CartProductVariant | No errors. |
| App\Entity\ProjectFile | No errors. |
| App\Entity\AttachmentImage | No errors. |
| App\Entity\Attachment | No errors. |