1.77 ms (20.73%)
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.49 ms (17.42%)
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.40 ms (16.47%)
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
0.71 ms (8.38%)
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_ WHERE s0_ . catalog_id_id IN (? )) 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_ WHERE s0_ . catalog_id_id IN (10 )) dctrn_result LIMIT 20 ;
Copy
0.63 ms (7.33%)
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_ WHERE s0_ . catalog_id_id IN (? )) 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_ WHERE s0_ . catalog_id_id IN (10 )) dctrn_result ) dctrn_table ;
Copy
0.52 ms (6.16%)
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.51 ms (6.03%)
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 WHERE t0 . id = ?
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 WHERE t0 . id = 10 ;
Copy
0.50 ms (5.91%)
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.50 ms (5.85%)
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.49 ms (5.71%)
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