11.64 ms (33.46%)
20
SELECT t0 . id AS id_1 , t0 . dose AS dose_2 , t0 . packs AS packs_3 , t0 . price AS price_4 , t0 . old_price AS old_price_5 , t0 . shop_item_id AS shop_item_id_6 FROM variants t0 WHERE t0 . shop_item_id = ?
SELECT t0 . id AS id_1 , t0 . dose AS dose_2 , t0 . packs AS packs_3 , t0 . price AS price_4 , t0 . old_price AS old_price_5 , t0 . shop_item_id AS shop_item_id_6 FROM variants t0 WHERE t0 . shop_item_id = 3 ;
Copy
11.64 ms (33.45%)
20
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . shop_item_id AS shop_item_id_3 FROM product_images t0 WHERE t0 . shop_item_id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . shop_item_id AS shop_item_id_3 FROM product_images t0 WHERE t0 . shop_item_id = 3 ;
Copy
1.99 ms (5.73%)
3
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . is_hit AS is_hit_3 , t0 . is_kit AS is_kit_4 , t0 . is_out_of_stock AS is_out_of_stock_5 , t0 . description AS description_6 , t0 . sku AS sku_7 , t0 . catalog_id_id AS catalog_id_id_8 FROM shop_items t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . is_hit AS is_hit_3 , t0 . is_kit AS is_kit_4 , t0 . is_out_of_stock AS is_out_of_stock_5 , t0 . description AS description_6 , t0 . sku AS sku_7 , t0 . catalog_id_id AS catalog_id_id_8 FROM shop_items t0 WHERE t0 . id = 3 ;
Copy
1.95 ms (5.60%)
3
SELECT p0_ . image AS image_0 FROM product_images p0_ WHERE p0_ . shop_item_id = ? LIMIT 1
SELECT p0_ . image AS image_0 FROM product_images p0_ WHERE p0_ . shop_item_id = 3 LIMIT 1 ;
Copy
1.60 ms (4.60%)
3
SELECT t0 . id AS id_1 , t0 . dose AS dose_2 , t0 . packs AS packs_3 , t0 . price AS price_4 , t0 . old_price AS old_price_5 , t0 . shop_item_id AS shop_item_id_6 FROM variants t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . dose AS dose_2 , t0 . packs AS packs_3 , t0 . price AS price_4 , t0 . old_price AS old_price_5 , t0 . shop_item_id AS shop_item_id_6 FROM variants t0 WHERE t0 . id = 1 ;
Copy
1.46 ms (4.20%)
1
SELECT COUNT (* ) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . is_hit AS is_hit_2 , s0_ . is_kit AS is_kit_3 , s0_ . is_out_of_stock AS is_out_of_stock_4 , s0_ . description AS description_5 , s0_ . sku AS sku_6 FROM shop_items s0_ ) dctrn_result ) dctrn_table
SELECT COUNT (* ) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . is_hit AS is_hit_2 , s0_ . is_kit AS is_kit_3 , s0_ . is_out_of_stock AS is_out_of_stock_4 , s0_ . description AS description_5 , s0_ . sku AS sku_6 FROM shop_items s0_ ) dctrn_result ) dctrn_table ;
Copy
1.05 ms (3.03%)
1
SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . is_hit AS is_hit_2 , s0_ . is_kit AS is_kit_3 , s0_ . is_out_of_stock AS is_out_of_stock_4 , s0_ . description AS description_5 , s0_ . sku AS sku_6 , s0_ . catalog_id_id AS catalog_id_id_7 FROM shop_items s0_ WHERE s0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
26
3
4
5
13
18
19
20
21
22
23
24
6
7
14
8
15
9
16
17
]
SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . is_hit AS is_hit_2 , s0_ . is_kit AS is_kit_3 , s0_ . is_out_of_stock AS is_out_of_stock_4 , s0_ . description AS description_5 , s0_ . sku AS sku_6 , s0_ . catalog_id_id AS catalog_id_id_7 FROM shop_items s0_ WHERE s0_ . id IN (26 , 3 , 4 , 5 , 13 , 18 , 19 , 20 , 21 , 22 , 23 , 24 , 6 , 7 , 14 , 8 , 15 , 9 , 16 , 17 );
Copy
0.99 ms (2.84%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . url AS url_3 , t0 . is_menu_item AS is_menu_item_4 , t0 . html AS html_5 FROM pages t0 WHERE t0 . is_menu_item = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . url AS url_3 , t0 . is_menu_item AS is_menu_item_4 , t0 . html AS html_5 FROM pages t0 WHERE t0 . is_menu_item = 1 ;
Copy
0.78 ms (2.23%)
1
SELECT DISTINCT id_0 FROM (SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . is_hit AS is_hit_2 , s0_ . is_kit AS is_kit_3 , s0_ . is_out_of_stock AS is_out_of_stock_4 , s0_ . description AS description_5 , s0_ . sku AS sku_6 FROM shop_items s0_ ) dctrn_result LIMIT 20
SELECT DISTINCT id_0 FROM (SELECT s0_ . id AS id_0 , s0_ . title AS title_1 , s0_ . is_hit AS is_hit_2 , s0_ . is_kit AS is_kit_3 , s0_ . is_out_of_stock AS is_out_of_stock_4 , s0_ . description AS description_5 , s0_ . sku AS sku_6 FROM shop_items s0_ ) dctrn_result LIMIT 20 ;
Copy
0.60 ms (1.73%)
1
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . count AS count_3 , t0 . discount AS discount_4 , t0 . is_free_item AS is_free_item_5 , t0 . shop_item_id AS shop_item_id_6 , t0 . variant_id AS variant_id_7 FROM shop_cart t0 WHERE t0 . session_id IS NULL
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . count AS count_3 , t0 . discount AS discount_4 , t0 . is_free_item AS is_free_item_5 , t0 . shop_item_id AS shop_item_id_6 , t0 . variant_id AS variant_id_7 FROM shop_cart t0 WHERE t0 . session_id IS NULL ;
Copy
0.59 ms (1.71%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . parent_id AS parent_id_3 , t0 . description AS description_4 , t0 . image AS image_5 , t0 . big_image AS big_image_6 FROM categories t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . parent_id AS parent_id_3 , t0 . description AS description_4 , t0 . image AS image_5 , t0 . big_image AS big_image_6 FROM categories t0 ;
Copy
0.50 ms (1.43%)
1
SELECT f0_ . id AS id_0 , f0_ . min_order AS min_order_1 , f0_ . variant_id AS variant_id_2 FROM free_products f0_ ORDER BY f0_ . min_order ASC
SELECT f0_ . id AS id_0 , f0_ . min_order AS min_order_1 , f0_ . variant_id AS variant_id_2 FROM free_products f0_ ORDER BY f0_ . min_order ASC ;
Copy