Photo Gallery

20 queries in 15.06ms

1. SELECT 1 FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = ? LIMIT 1 [core_pages] 1.71ms · 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.22ms · db_table_exists > db_select_row

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

4. SELECT * FROM app_services WHERE status = ? ORDER BY pos ASC LIMIT ? [active, 30] 0.64ms · 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.54ms · get_page_row > db_select_row

6. SELECT title, body FROM core_text WHERE page = ? ORDER BY pos ASC [18] 0.53ms · 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.45ms · get_page_row > db_select_row

8. SELECT title, body FROM core_text WHERE page = ? ORDER BY pos ASC [1] 0.48ms · 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.54ms · 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.41ms · get_page_row > db_select_row

11. SELECT title, body FROM core_text WHERE page = ? ORDER BY pos ASC [3] 0.46ms · 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.45ms · get_page_row > db_select_row

13. SELECT title, body FROM core_text WHERE page = ? ORDER BY pos ASC [9] 0.51ms · 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.58ms · 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] 1.86ms · 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] 1.56ms · 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.42ms · 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] 0.75ms · 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.69ms · 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] 0.65ms · get_page_text > db_select_row