New Arrivals

7 queries in 9.84ms

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

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

4. SELECT * FROM app_shop_categories WHERE url = ? AND status = 'active' LIMIT 1 [new-arrivals] 1.24ms · 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.38ms · 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 (?)) ) [2, 2] 1.84ms · 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 [2, 2] 0.52ms · shop_products_in_category > db_select_rows