Photo Gallery

20 queries in 17.19ms

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

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

3. SELECT name, value FROM core_settings 0.56ms · settings_cache > db_select_rows

4. SELECT * FROM app_services WHERE status = ? ORDER BY pos ASC LIMIT ? [active, 30] 0.59ms · db_select_simple > db_select_rows

5. SELECT id, title, meta_title, meta_desc FROM core_pages WHERE title = ? AND status = 'active' LIMIT 1 [Global] 0.44ms · get_page_row > db_select_row

6. SELECT title, body FROM core_text WHERE page = ? ORDER BY pos ASC [18] 0.69ms · get_page_text > db_select_rows

7. SELECT id, title, meta_title, meta_desc FROM core_pages WHERE title = ? AND status = 'active' LIMIT 1 [Home] 0.47ms · get_page_row > db_select_row

8. SELECT title, body FROM core_text WHERE page = ? ORDER BY pos ASC [1] 0.93ms · get_page_text > db_select_rows

9. SELECT title, img, alt FROM core_imgs WHERE page = ? AND status = 'active' ORDER BY pos ASC [1] 0.85ms · get_page_images > db_select_rows

10. SELECT id, title, meta_title, meta_desc FROM core_pages WHERE title = ? AND status = 'active' LIMIT 1 [Contact] 0.78ms · get_page_row > db_select_row

11. SELECT title, body FROM core_text WHERE page = ? ORDER BY pos ASC [3] 0.75ms · get_page_text > db_select_rows

12. SELECT id, title, meta_title, meta_desc FROM core_pages WHERE title = ? AND status = 'active' LIMIT 1 [Gallery] 0.93ms · get_page_row > db_select_row

13. SELECT title, body FROM core_text WHERE page = ? ORDER BY pos ASC [9] 0.84ms · get_page_text > db_select_rows

14. SELECT title, img, alt FROM core_imgs WHERE page = ? AND status = 'active' ORDER BY pos ASC [9] 0.81ms · get_page_images > db_select_rows

15. SELECT id, title, url, description, cover_image, featured, pos, layout, thumb_crop, order_mode, show_captions, lightbox, allow_downloads FROM app_gallery_albums WHERE status = ? ORDER BY pos ASC, id ASC [active] 0.97ms · gallery_active_albums > db_select_rows

16. SELECT album_id, COUNT(*) AS image_count FROM app_gallery_images WHERE album_id IN (?) AND status = ? AND img IS NOT NULL AND img <> '' GROUP BY album_id [1, active] 0.81ms · gallery_image_counts > db_select_rows

17. SELECT id, album_id, title, alt, img, focal_x, focal_y, pos, date_added FROM app_gallery_images WHERE id IN (?) AND status = ? AND img IS NOT NULL AND img <> '' [1, active] 0.87ms · gallery_images_by_ids > db_select_rows

18. SELECT t.title, t.body FROM core_text t INNER JOIN core_pages p ON p.id = t.page WHERE p.title = ? AND p.status = 'active' AND t.title = ? LIMIT 1 [Contact, Facebook URL] 1.02ms · get_page_text > db_select_row

19. SELECT t.title, t.body FROM core_text t INNER JOIN core_pages p ON p.id = t.page WHERE p.title = ? AND p.status = 'active' AND t.title = ? LIMIT 1 [Contact, Instagram URL] 0.87ms · get_page_text > db_select_row

20. SELECT t.title, t.body FROM core_text t INNER JOIN core_pages p ON p.id = t.page WHERE p.title = ? AND p.status = 'active' AND t.title = ? LIMIT 1 [Contact, Google My Business] 1.13ms · get_page_text > db_select_row