| 1 |
1.90 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 = '293';
|
| 2 |
0.69 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 = ?
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 = 2;
|
| 3 |
0.57 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 = ?
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 = 8;
|
| 4 |
3.04 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 = 293 AND p4_.visible = true AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id ORDER BY a0_.sort_path ASC;
|
| 5 |
1.18 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
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 = 293 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 1 GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.id ASC;
|
| 6 |
0.41 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 = 293;
|
| 7 |
1.65 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: [
293
1
11135
14966
14967
14968
14969
14970
14971
15583
16275
14886
11003
11004
11005
11006
11007
11008
11009
11010
11011
11012
11013
11014
11036
11037
11038
11039
11040
11041
11118
11119
11120
11121
11122
11123
11130
11131
11132
11133
11134
11163
11164
11165
11166
11167
11168
11253
11254
11255
11256
11257
11258
11351
11352
11353
11354
11355
11356
14881
14882
14883
14884
14885
15260
15261
15262
15263
15264
15265
15368
15369
15370
15371
15372
15373
15579
15580
15581
15582
15584
15659
15660
15661
15662
15663
15664
15903
15904
15905
15906
15907
15908
16264
16265
16266
16267
16268
16269
16270
16271
16272
16273
16274
]
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
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 = 293 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 1 AND p3_.id IN (11135, 14966, 14967, 14968, 14969, 14970, 14971, 15583, 16275, 14886, 11003, 11004, 11005, 11006, 11007, 11008, 11009, 11010, 11011, 11012, 11013, 11014, 11036, 11037, 11038, 11039, 11040, 11041, 11118, 11119, 11120, 11121, 11122, 11123, 11130, 11131, 11132, 11133, 11134, 11163, 11164, 11165, 11166, 11167, 11168, 11253, 11254, 11255, 11256, 11257, 11258, 11351, 11352, 11353, 11354, 11355, 11356, 14881, 14882, 14883, 14884, 14885, 15260, 15261, 15262, 15263, 15264, 15265, 15368, 15369, 15370, 15371, 15372, 15373, 15579, 15580, 15581, 15582, 15584, 15659, 15660, 15661, 15662, 15663, 15664, 15903, 15904, 15905, 15906, 15907, 15908, 16264, 16265, 16266, 16267, 16268, 16269, 16270, 16271, 16272, 16273, 16274) ORDER BY a0_.id ASC;
|
| 8 |
1.51 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 = 293 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 10 GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.value ASC;
|
| 9 |
0.38 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 = 293;
|
| 10 |
1.45 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: [
293
10
11135
14966
14967
14968
14969
14970
14971
15583
16275
14886
11003
11004
11005
11006
11007
11008
11009
11010
11011
11012
11013
11014
11036
11037
11038
11039
11040
11041
11118
11119
11120
11121
11122
11123
11130
11131
11132
11133
11134
11163
11164
11165
11166
11167
11168
11253
11254
11255
11256
11257
11258
11351
11352
11353
11354
11355
11356
14881
14882
14883
14884
14885
15260
15261
15262
15263
15264
15265
15368
15369
15370
15371
15372
15373
15579
15580
15581
15582
15584
15659
15660
15661
15662
15663
15664
15903
15904
15905
15906
15907
15908
16264
16265
16266
16267
16268
16269
16270
16271
16272
16273
16274
]
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 = 293 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 10 AND p3_.id IN (11135, 14966, 14967, 14968, 14969, 14970, 14971, 15583, 16275, 14886, 11003, 11004, 11005, 11006, 11007, 11008, 11009, 11010, 11011, 11012, 11013, 11014, 11036, 11037, 11038, 11039, 11040, 11041, 11118, 11119, 11120, 11121, 11122, 11123, 11130, 11131, 11132, 11133, 11134, 11163, 11164, 11165, 11166, 11167, 11168, 11253, 11254, 11255, 11256, 11257, 11258, 11351, 11352, 11353, 11354, 11355, 11356, 14881, 14882, 14883, 14884, 14885, 15260, 15261, 15262, 15263, 15264, 15265, 15368, 15369, 15370, 15371, 15372, 15373, 15579, 15580, 15581, 15582, 15584, 15659, 15660, 15661, 15662, 15663, 15664, 15903, 15904, 15905, 15906, 15907, 15908, 16264, 16265, 16266, 16267, 16268, 16269, 16270, 16271, 16272, 16273, 16274) ORDER BY a0_.value ASC;
|
| 11 |
0.49 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 = 293;
|
| 12 |
0.35 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 = 293;
|
| 13 |
2.15 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: [
293
11135
14966
14967
14968
14969
14970
14971
15583
16275
14886
11003
11004
11005
11006
11007
11008
11009
11010
11011
11012
11013
11014
11036
11037
11038
11039
11040
11041
11118
11119
11120
11121
11122
11123
11130
11131
11132
11133
11134
11163
11164
11165
11166
11167
11168
11253
11254
11255
11256
11257
11258
11351
11352
11353
11354
11355
11356
14881
14882
14883
14884
14885
15260
15261
15262
15263
15264
15265
15368
15369
15370
15371
15372
15373
15579
15580
15581
15582
15584
15659
15660
15661
15662
15663
15664
15903
15904
15905
15906
15907
15908
16264
16265
16266
16267
16268
16269
16270
16271
16272
16273
16274
]
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 = 293 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (11135, 14966, 14967, 14968, 14969, 14970, 14971, 15583, 16275, 14886, 11003, 11004, 11005, 11006, 11007, 11008, 11009, 11010, 11011, 11012, 11013, 11014, 11036, 11037, 11038, 11039, 11040, 11041, 11118, 11119, 11120, 11121, 11122, 11123, 11130, 11131, 11132, 11133, 11134, 11163, 11164, 11165, 11166, 11167, 11168, 11253, 11254, 11255, 11256, 11257, 11258, 11351, 11352, 11353, 11354, 11355, 11356, 14881, 14882, 14883, 14884, 14885, 15260, 15261, 15262, 15263, 15264, 15265, 15368, 15369, 15370, 15371, 15372, 15373, 15579, 15580, 15581, 15582, 15584, 15659, 15660, 15661, 15662, 15663, 15664, 15903, 15904, 15905, 15906, 15907, 15908, 16264, 16265, 16266, 16267, 16268, 16269, 16270, 16271, 16272, 16273, 16274) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC;
|
| 14 |
1.49 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 = 293 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;
|
| 15 |
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 = 293;
|
| 16 |
1.06 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: [
293
11135
14966
14967
14968
14969
14970
14971
15583
16275
14886
11003
11004
11005
11006
11007
11008
11009
11010
11011
11012
11013
11014
11036
11037
11038
11039
11040
11041
11118
11119
11120
11121
11122
11123
11130
11131
11132
11133
11134
11163
11164
11165
11166
11167
11168
11253
11254
11255
11256
11257
11258
11351
11352
11353
11354
11355
11356
14881
14882
14883
14884
14885
15260
15261
15262
15263
15264
15265
15368
15369
15370
15371
15372
15373
15579
15580
15581
15582
15584
15659
15660
15661
15662
15663
15664
15903
15904
15905
15906
15907
15908
16264
16265
16266
16267
16268
16269
16270
16271
16272
16273
16274
]
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 = 293 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (11135, 14966, 14967, 14968, 14969, 14970, 14971, 15583, 16275, 14886, 11003, 11004, 11005, 11006, 11007, 11008, 11009, 11010, 11011, 11012, 11013, 11014, 11036, 11037, 11038, 11039, 11040, 11041, 11118, 11119, 11120, 11121, 11122, 11123, 11130, 11131, 11132, 11133, 11134, 11163, 11164, 11165, 11166, 11167, 11168, 11253, 11254, 11255, 11256, 11257, 11258, 11351, 11352, 11353, 11354, 11355, 11356, 14881, 14882, 14883, 14884, 14885, 15260, 15261, 15262, 15263, 15264, 15265, 15368, 15369, 15370, 15371, 15372, 15373, 15579, 15580, 15581, 15582, 15584, 15659, 15660, 15661, 15662, 15663, 15664, 15903, 15904, 15905, 15906, 15907, 15908, 16264, 16265, 16266, 16267, 16268, 16269, 16270, 16271, 16272, 16273, 16274);
|
| 17 |
0.46 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;
|
| 18 |
0.27 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 19 |
1.21 ms |
INSERT INTO cart (created_at, updated_at, owner_id, shipping_method_id, payment_method_id) VALUES (?, ?, ?, ?, ?)
Parameters: [
"2026-03-19 23:10:13"
"2026-03-19 23:10:13"
null
null
null
]
INSERT INTO cart (created_at, updated_at, owner_id, shipping_method_id, payment_method_id) VALUES ('2026-03-19 23:10:13', '2026-03-19 23:10:13', NULL, NULL, NULL);
|
| 20 |
12.07 ms |
"COMMIT"
|
| 21 |
2.92 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 = ?
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 = ?
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 = 205;
|
| 22 |
0.63 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 = 293;
|
| 23 |
0.77 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 = 577;
|
| 24 |
0.98 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 = 1;
|
| 25 |
0.93 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 = 578;
|
| 26 |
0.64 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 = 2;
|