Harbour & Lane

6 queries in 5.28ms

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

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

4. SELECT * FROM app_shop_brands WHERE url = ? AND status = 'active' LIMIT 1 [harbour-and-lane] 0.60ms · shop_brand_by_url > db_select_row

5. SELECT COUNT(*) AS n FROM app_shop_products WHERE status = 'active' AND brand = ? [3] 0.59ms · shop_count_products_by_brand > db_select_row

6. SELECT id, sku, title, url, type, brand, cat, price, sale_price, stock, track_stock, img, intro, featured FROM app_shop_products WHERE status = 'active' AND brand = ? ORDER BY pos ASC, title ASC LIMIT 0, 24 [3] 0.62ms · shop_products_by_brand > db_select_rows