Acme Co.

6 queries in 4.66ms

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

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

4. SELECT * FROM app_shop_brands WHERE url = ? AND status = 'active' LIMIT 1 [acme-co] 0.57ms · shop_brand_by_url > db_select_row

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