| 1 |
1.08 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 = ?
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 = '356';
|
| 2 |
0.43 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 356;
|
| 3 |
2.57 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: [
356
14706
14707
14708
14709
14710
14711
14712
14713
14714
14715
14716
14717
14736
14737
14738
14739
14740
14741
14828
14829
14830
14831
14832
14833
14912
14913
14914
14915
14916
14917
14918
14919
14920
14921
14922
14923
14971
14972
14973
14974
14975
14976
14983
14984
14985
14986
14987
14988
15203
15204
15205
15206
15207
15208
15222
15223
15224
15225
15226
15227
15264
15265
15266
15267
15268
15269
15325
15326
15327
15328
15329
15330
15356
15357
15358
15359
15360
15361
18064
18065
18066
18067
18068
18613
18614
18615
18616
18617
]
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
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 = 356 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (14706, 14707, 14708, 14709, 14710, 14711, 14712, 14713, 14714, 14715, 14716, 14717, 14736, 14737, 14738, 14739, 14740, 14741, 14828, 14829, 14830, 14831, 14832, 14833, 14912, 14913, 14914, 14915, 14916, 14917, 14918, 14919, 14920, 14921, 14922, 14923, 14971, 14972, 14973, 14974, 14975, 14976, 14983, 14984, 14985, 14986, 14987, 14988, 15203, 15204, 15205, 15206, 15207, 15208, 15222, 15223, 15224, 15225, 15226, 15227, 15264, 15265, 15266, 15267, 15268, 15269, 15325, 15326, 15327, 15328, 15329, 15330, 15356, 15357, 15358, 15359, 15360, 15361, 18064, 18065, 18066, 18067, 18068, 18613, 18614, 18615, 18616, 18617) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC;
|
| 4 |
2.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
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 = 356 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;
|
| 5 |
1.88 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
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 = 356 AND p4_.visible = true AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id ORDER BY a0_.sort_path ASC;
|
| 6 |
0.71 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
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 = 356 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 34 GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.value ASC;
|
| 7 |
0.21 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 356;
|
| 8 |
1.07 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: [
356
34
14706
14707
14708
14709
14710
14711
14712
14713
14714
14715
14716
14717
14736
14737
14738
14739
14740
14741
14828
14829
14830
14831
14832
14833
14912
14913
14914
14915
14916
14917
14918
14919
14920
14921
14922
14923
14971
14972
14973
14974
14975
14976
14983
14984
14985
14986
14987
14988
15203
15204
15205
15206
15207
15208
15222
15223
15224
15225
15226
15227
15264
15265
15266
15267
15268
15269
15325
15326
15327
15328
15329
15330
15356
15357
15358
15359
15360
15361
18064
18065
18066
18067
18068
18613
18614
18615
18616
18617
]
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
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 = 356 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 34 AND p3_.id IN (14706, 14707, 14708, 14709, 14710, 14711, 14712, 14713, 14714, 14715, 14716, 14717, 14736, 14737, 14738, 14739, 14740, 14741, 14828, 14829, 14830, 14831, 14832, 14833, 14912, 14913, 14914, 14915, 14916, 14917, 14918, 14919, 14920, 14921, 14922, 14923, 14971, 14972, 14973, 14974, 14975, 14976, 14983, 14984, 14985, 14986, 14987, 14988, 15203, 15204, 15205, 15206, 15207, 15208, 15222, 15223, 15224, 15225, 15226, 15227, 15264, 15265, 15266, 15267, 15268, 15269, 15325, 15326, 15327, 15328, 15329, 15330, 15356, 15357, 15358, 15359, 15360, 15361, 18064, 18065, 18066, 18067, 18068, 18613, 18614, 18615, 18616, 18617) ORDER BY a0_.value ASC;
|
| 9 |
0.66 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
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 = 356 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 35 GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id;
|
| 10 |
0.21 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 356;
|
| 11 |
1.05 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
356
35
14706
14707
14708
14709
14710
14711
14712
14713
14714
14715
14716
14717
14736
14737
14738
14739
14740
14741
14828
14829
14830
14831
14832
14833
14912
14913
14914
14915
14916
14917
14918
14919
14920
14921
14922
14923
14971
14972
14973
14974
14975
14976
14983
14984
14985
14986
14987
14988
15203
15204
15205
15206
15207
15208
15222
15223
15224
15225
15226
15227
15264
15265
15266
15267
15268
15269
15325
15326
15327
15328
15329
15330
15356
15357
15358
15359
15360
15361
18064
18065
18066
18067
18068
18613
18614
18615
18616
18617
]
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 (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
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 = 356 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 35 AND p3_.id IN (14706, 14707, 14708, 14709, 14710, 14711, 14712, 14713, 14714, 14715, 14716, 14717, 14736, 14737, 14738, 14739, 14740, 14741, 14828, 14829, 14830, 14831, 14832, 14833, 14912, 14913, 14914, 14915, 14916, 14917, 14918, 14919, 14920, 14921, 14922, 14923, 14971, 14972, 14973, 14974, 14975, 14976, 14983, 14984, 14985, 14986, 14987, 14988, 15203, 15204, 15205, 15206, 15207, 15208, 15222, 15223, 15224, 15225, 15226, 15227, 15264, 15265, 15266, 15267, 15268, 15269, 15325, 15326, 15327, 15328, 15329, 15330, 15356, 15357, 15358, 15359, 15360, 15361, 18064, 18065, 18066, 18067, 18068, 18613, 18614, 18615, 18616, 18617);
|
| 12 |
0.20 ms |
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?
SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 356;
|
| 13 |
0.68 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: [
356
14706
14707
14708
14709
14710
14711
14712
14713
14714
14715
14716
14717
14736
14737
14738
14739
14740
14741
14828
14829
14830
14831
14832
14833
14912
14913
14914
14915
14916
14917
14918
14919
14920
14921
14922
14923
14971
14972
14973
14974
14975
14976
14983
14984
14985
14986
14987
14988
15203
15204
15205
15206
15207
15208
15222
15223
15224
15225
15226
15227
15264
15265
15266
15267
15268
15269
15325
15326
15327
15328
15329
15330
15356
15357
15358
15359
15360
15361
18064
18065
18066
18067
18068
18613
18614
18615
18616
18617
]
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 (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
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 = 356 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (14706, 14707, 14708, 14709, 14710, 14711, 14712, 14713, 14714, 14715, 14716, 14717, 14736, 14737, 14738, 14739, 14740, 14741, 14828, 14829, 14830, 14831, 14832, 14833, 14912, 14913, 14914, 14915, 14916, 14917, 14918, 14919, 14920, 14921, 14922, 14923, 14971, 14972, 14973, 14974, 14975, 14976, 14983, 14984, 14985, 14986, 14987, 14988, 15203, 15204, 15205, 15206, 15207, 15208, 15222, 15223, 15224, 15225, 15226, 15227, 15264, 15265, 15266, 15267, 15268, 15269, 15325, 15326, 15327, 15328, 15329, 15330, 15356, 15357, 15358, 15359, 15360, 15361, 18064, 18065, 18066, 18067, 18068, 18613, 18614, 18615, 18616, 18617);
|
| 14 |
0.43 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
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;
|
| 15 |
2.34 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 = ?
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 = 356;
|
| 16 |
0.56 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 = ?
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 = 702;
|
| 17 |
0.42 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 = ?
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 = 5;
|
| 18 |
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 = ?
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 = 703;
|
| 19 |
0.15 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 = ?
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 = 6;
|