| 1 |
1.16 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sort_order AS sort_order_3, p0_.effective_price AS effective_price_4, p0_.status AS status_5, p0_.type AS type_6, p0_.quantity AS quantity_7, p0_.options_json AS options_json_8, p0_.attribute_json AS attribute_json_9, p0_.code AS code_10, p0_.description AS description_11, p0_.similar_group_id AS similar_group_id_12, p0_.price AS price_13, p0_.sale_price AS sale_price_14, p0_.currency AS currency_15, p0_.date_added AS date_added_16, p0_.date_edited AS date_edited_17, p0_.manufacturer_id AS manufacturer_id_18, p0_.series_id AS series_id_19 FROM product p0_ ORDER BY p0_.id DESC LIMIT 10
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sort_order AS sort_order_3, p0_.effective_price AS effective_price_4, p0_.status AS status_5, p0_.type AS type_6, p0_.quantity AS quantity_7, p0_.options_json AS options_json_8, p0_.attribute_json AS attribute_json_9, p0_.code AS code_10, p0_.description AS description_11, p0_.similar_group_id AS similar_group_id_12, p0_.price AS price_13, p0_.sale_price AS sale_price_14, p0_.currency AS currency_15, p0_.date_added AS date_added_16, p0_.date_edited AS date_edited_17, p0_.manufacturer_id AS manufacturer_id_18, p0_.series_id AS series_id_19 FROM product p0_ ORDER BY p0_.id DESC LIMIT 10;
|
| 2 |
1.08 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 258;
|
| 3 |
2.00 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 257;
|
| 4 |
1.46 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 256;
|
| 5 |
0.78 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 255;
|
| 6 |
0.78 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 254;
|
| 7 |
0.32 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 253;
|
| 8 |
0.38 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 252;
|
| 9 |
0.30 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 251;
|
| 10 |
0.31 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 250;
|
| 11 |
0.30 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 249;
|
| 12 |
0.39 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 258;
|
| 13 |
0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.visibility AS visibility_4, t0.parent_category_id AS parent_category_id_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.meta_keywords AS meta_keywords_8, t0.sort_order AS sort_order_9, t0.meta_h1 AS meta_h1_10, t0.description AS description_11, t0.navbar_visibility AS navbar_visibility_12, t0.footer_visibility AS footer_visibility_13 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.visibility AS visibility_4, t0.parent_category_id AS parent_category_id_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.meta_keywords AS meta_keywords_8, t0.sort_order AS sort_order_9, t0.meta_h1 AS meta_h1_10, t0.description AS description_11, t0.navbar_visibility AS navbar_visibility_12, t0.footer_visibility AS footer_visibility_13 FROM category t0 WHERE t0.id = 6;
|
| 14 |
0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.visibility AS visibility_4, t0.parent_category_id AS parent_category_id_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.meta_keywords AS meta_keywords_8, t0.sort_order AS sort_order_9, t0.meta_h1 AS meta_h1_10, t0.description AS description_11, t0.navbar_visibility AS navbar_visibility_12, t0.footer_visibility AS footer_visibility_13 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.visibility AS visibility_4, t0.parent_category_id AS parent_category_id_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.meta_keywords AS meta_keywords_8, t0.sort_order AS sort_order_9, t0.meta_h1 AS meta_h1_10, t0.description AS description_11, t0.navbar_visibility AS navbar_visibility_12, t0.footer_visibility AS footer_visibility_13 FROM category t0 WHERE t0.id = 19;
|
| 15 |
0.44 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 258 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 16 |
0.49 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 257;
|
| 17 |
0.52 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 257 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 18 |
0.33 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 256;
|
| 19 |
0.36 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 256 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 20 |
0.34 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 255;
|
| 21 |
0.34 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 255 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 22 |
0.32 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 254;
|
| 23 |
0.42 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 254 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 24 |
0.32 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 253;
|
| 25 |
0.35 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 253 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 26 |
0.30 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 252;
|
| 27 |
0.35 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 252 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 28 |
0.36 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 251;
|
| 29 |
0.31 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 251 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 30 |
0.31 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 250;
|
| 31 |
0.32 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 250 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 32 |
0.32 ms |
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = 249;
|
| 33 |
0.31 ms |
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = 249 ORDER BY t0.sort_order ASC LIMIT 1;
|
| 34 |
1.97 ms |
SELECT p0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM product p0_ LEFT JOIN product_option_value_assignment p1_ ON p0_.id = p1_.product_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.type IN (?, ?) GROUP BY p0_.id
Parameters: [
258
257
256
255
254
253
252
251
250
249
"variable"
"variable_no_prices"
]
SELECT p0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM product p0_ LEFT JOIN product_option_value_assignment p1_ ON p0_.id = p1_.product_id WHERE p0_.id IN (258, 257, 256, 255, 254, 253, 252, 251, 250, 249) AND p0_.type IN ('variable', 'variable_no_prices') GROUP BY p0_.id;
|
| 35 |
0.61 ms |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_;
|