Featured

7 queries in 4.93ms

1. SELECT 1 FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = ? LIMIT 1 [core_pages] 1.33ms · db_table_exists > db_select_row

2. SELECT name, value FROM core_settings 0.43ms · settings_cache > db_select_rows

3. SELECT 1 FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = ? LIMIT 1 [app_shop_customer_sessions] 1.01ms · db_table_exists > db_select_row

4. SELECT * FROM app_shop_categories WHERE url = ? AND status = 'active' LIMIT 1 [featured] 0.47ms · shop_category_by_url > db_select_row

5. SELECT id, parent, title, url, img, intro, featured, pos FROM app_shop_categories WHERE status = 'active' ORDER BY pos ASC, title ASC 0.46ms · shop_all_categories > db_select_rows

6. SELECT COUNT(DISTINCT p.id) AS n FROM app_shop_products p WHERE p.status = 'active' AND ( p.cat IN (?) OR p.id IN (SELECT product FROM app_shop_product_categories WHERE category IN (?)) ) [1, 1] 0.69ms · shop_count_products_in_category > db_select_row

7. SELECT DISTINCT id, sku, title, url, type, brand, cat, price, sale_price, stock, track_stock, img, intro, featured FROM app_shop_products p WHERE p.status = 'active' AND ( p.cat IN (?) OR p.id IN (SELECT product FROM app_shop_product_categories WHERE category IN (?)) ) ORDER BY p.pos ASC, p.title ASC LIMIT 0, 24 [1, 1] 0.54ms · shop_products_in_category > db_select_rows