Northwind

6 queries in 5.84ms

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

2. SELECT name, value FROM core_settings 0.35ms · 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_brands WHERE url = ? AND status = 'active' LIMIT 1 [northwind] 1.39ms · shop_brand_by_url > db_select_row

5. SELECT COUNT(*) AS n FROM app_shop_products WHERE status = 'active' AND brand = ? [2] 1.29ms · 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 [2] 0.53ms · shop_products_by_brand > db_select_rows