Accessories

7 queries in 19.98ms

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

2. SELECT name, value FROM core_settings 1.01ms · 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] 2.51ms · db_table_exists > db_select_row

4. SELECT * FROM app_shop_categories WHERE url = ? AND status = 'active' LIMIT 1 [accessories] 0.78ms · 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.87ms · 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 (?)) ) [3, 3] 5.44ms · 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 [3, 3] 2.10ms · shop_products_in_category > db_select_rows