0.35 ms SELECT * FROM channels ORDER BY sort_order, id
32.22 ms SHOW TABLES LIKE 'bsw_meta'
0.19 ms SELECT v FROM bsw_meta WHERE k = ? LIMIT 1
39.09 ms SHOW TABLES LIKE 'bg_inventory'
8.38 ms SHOW COLUMNS FROM bg_inventory
21.79 ms SHOW TABLES LIKE 'bsw_set_coming_soon'
1.66 ms SELECT COUNT(*) FROM oc_product p JOIN (SELECT DISTINCT product_id FROM bg_inventory WHERE quantity > 0 UNION SELECT product_id FROM bsw_set_coming_soon WHERE released_at
64.42 ms SELECT COUNT(*) FROM oc_product p JOIN (SELECT DISTINCT product_id FROM bg_inventory WHERE quantity > 0 UNION SELECT product_id FROM bsw_set_coming_soon WHERE released_at
29.25 ms SELECT MIN(price) FROM oc_product_unit pu JOIN oc_product p ON p.product_id = pu.product_id JOIN (SELECT DISTINCT product_id FROM bg_inventory WHERE quantity > 0
40.51 ms SELECT c.category_id, cd.name, cd.path AS slug, COUNT(DISTINCT p.product_id) AS cnt FROM oc_category c JOIN oc_category_description cd ON cd.cate
64.85 ms SELECT COUNT(*) FROM ( SELECT 1 FROM oc_product p JOIN (SELECT DISTINCT product_id FROM bg_inventory WHERE quantity > 0 UNION SELECT product_id FROM b
0.38 ms SELECT v FROM bsw_meta WHERE k = ? LIMIT 1
6.47 ms SELECT p.product_id, p.model, p.image, p.date_created, p.viewed, p.age_category_id, p.location, p.y