Plzeňsko
EuropeCzech RepublicUstiSouthbohemiaPilsenLiberecHradecSlovakiaSlovakia
Share
Tweet
English (United Kingdom)
English (United Kingdom) Czech (Czech Republic)

Map

Date

Keywords

Found result

More result 1 / 3 < >

$_COOKIE

Request

action => 'index'
controller => 'map'
id => 1578
module => 'default'

View vars

category => Application_Model_Category Object()
franchise => Application_Model_Franchise Object()
from => ''
main_slider => NULL
month => ''
paginator => Zend_Paginator Object()
params => stdClass Object()
places_venues => Zend_Db_Table_Rowset Object()
section => 'map'
selected =>
to => ''

Custom Timers

Controller: 1224.88 ms

Overall Timers

default
map
index
Avg: 1376.66 ms / 1 requests
Min: 1376.66 ms
Max: 1376.66 ms

Reset timers by sending ZFDEBUG_RESET as a GET/POST parameter

Memory Usage

Controller: 8877.9K

Database queries

Metadata cache is DISABLED

Adapter 0

  1. [1.06 ms] DESCRIBE `valid_franchises_view`
  2. [0.82 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (domain = 'www.plzenskykalendar.cz') LIMIT 1
  3. [2.1 ms] DESCRIBE `franchises`
  4. [0.2 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '37') LIMIT 1
  5. [0.58 ms] DESCRIBE `franchises_languages`
  6. [0.17 ms] SELECT `franchises_languages`.* FROM `franchises_languages` WHERE (franchise_id = '37')
  7. [0.57 ms] DESCRIBE `languages`
  8. [0.17 ms] SELECT `languages`.* FROM `languages` WHERE (id = '50') LIMIT 1
  9. [2.01 ms] DESCRIBE `franchises`
  10. [0.22 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '37') LIMIT 1
  11. [0.92 ms] DESCRIBE `calendar`
  12. [1.24 ms] SELECT `c`.* FROM `calendar` AS `c` WHERE (date >= DATE(NOW())) AND (is_top = 1) AND (franchise_id = '37') GROUP BY `event_id` ORDER BY RAND() ASC LIMIT 10
  13. [1.45 ms] DESCRIBE `events`
  14. [1.28 ms] SELECT `events`.* FROM `events` WHERE (id IN ('40652','40644','40642','40653','24179','44824','40646')) ORDER BY RAND() ASC
  15. [1.15 ms] DESCRIBE `surveys`
  16. [0.4 ms] SELECT `surveys`.* FROM `surveys` WHERE (FIND_IN_SET('sidebar', page_position) > 0) AND (franchise_id = '37') AND (now() BETWEEN valid_from AND valid_to) AND (is_active = 1) AND (is_deleted = 0)
  17. [0.88 ms] DESCRIBE `categories`
  18. [0.2 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'map') AND (parent_id IS NULL) LIMIT 1
  19. [1.46 ms] DESCRIBE `events`
  20. [4.39 ms] SELECT COUNT(DISTINCT `c`.`event_id`) AS `zend_paginator_row_count` FROM `events` AS `e` INNER JOIN `calendar` AS `c` ON e.id = c.event_id INNER JOIN `events_places` AS `ep` ON ep.event_id = e.id INNER JOIN `places` AS `p` ON p.id = ep.place_id WHERE (e.franchise_id = '37') AND (e.is_active = 1) AND (e.is_deleted = 0) AND (p.is_active = 1) AND (p.is_deleted = 0) AND (EXISTS (SELECT 1 FROM events_categories WHERE event_id = c.event_id)) AND (c.date >= '2013-05-24')
  21. [1.54 ms] DESCRIBE `places`
  22. [2.95 ms] SELECT `p`.* FROM `places` AS `p` WHERE (p.franchise_id = '37') AND (p.is_active = 1) AND (p.is_deleted = 0) AND (EXISTS (SELECT 1 FROM places_categories WHERE place_id = p.id)) GROUP BY `p`.`id` LIMIT 100
  23. [0.75 ms] DESCRIBE `translations`
  24. [0.18 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  25. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Map') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  26. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  27. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Date') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  28. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  29. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Categories') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  30. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  31. [0.19 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Date') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  32. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  33. [0.18 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'From') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  34. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  35. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'to') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  36. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  37. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'January') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  38. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  39. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'February') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  40. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  41. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'March') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  42. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  43. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'April') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  44. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  45. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'May') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  46. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  47. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'June') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  48. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  49. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'July') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  50. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  51. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'August') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  52. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  53. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Semptember') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  54. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  55. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'October') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  56. [0.18 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  57. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'November') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  58. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  59. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'December') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  60. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  61. [0.19 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'All') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  62. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  63. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Today') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  64. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  65. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Tomorrow') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  66. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  67. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Weekend') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  68. [0.17 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'events') AND (parent_id IS NULL) LIMIT 1
  69. [0.85 ms] DESCRIBE `categories`
  70. [0.48 ms] SELECT `categories`.* FROM `categories` WHERE (is_deleted = 0) AND (is_active = 1) AND (franchise_id = '37') ORDER BY `weight` DESC
  71. [0.77 ms] DESCRIBE `translations`
  72. [0.32 ms] SELECT `t`.`text`, `t`.`type`, `ct`.`category_id` AS `id` FROM `translations` AS `t` INNER JOIN `categories_translations` AS `ct` ON ct.translation_id = t.id INNER JOIN `categories` AS `c` ON c.id = ct.category_id WHERE (t.language_id = '50') AND (c.franchise_id = '37') AND (c.is_deleted = 0) AND (c.is_active = 1)
  73. [0.19 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'places') AND (parent_id IS NULL) LIMIT 1
  74. [0.21 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  75. [0.19 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Mark all categories') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  76. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  77. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Select a period') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  78. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  79. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Keywords') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  80. [0.18 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  81. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Search') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  82. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  83. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Found result') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  84. [14.28 ms] SELECT `e`.*, 'event' AS object_type, `c`.`term_id`, `c`.`valid_from`, `c`.`valid_to`, `c`.`day`, `c`.`date`, `p`.`map_longitude`, `p`.`map_latitude`, `p`.`contact_address`, `p`.`name` AS `place_name` FROM `events` AS `e` INNER JOIN `calendar` AS `c` ON e.id = c.event_id INNER JOIN `events_places` AS `ep` ON ep.event_id = e.id INNER JOIN `places` AS `p` ON p.id = ep.place_id WHERE (e.franchise_id = '37') AND (e.is_active = 1) AND (e.is_deleted = 0) AND (p.is_active = 1) AND (p.is_deleted = 0) AND (EXISTS (SELECT 1 FROM events_categories WHERE event_id = c.event_id)) AND (c.date >= '2013-05-24') GROUP BY `c`.`event_id` LIMIT 100
  85. [0.69 ms] DESCRIBE `categories`
  86. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37921' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  87. [0.5 ms] DESCRIBE `translations`
  88. [2.36 ms] SELECT `t`.`text`, `t`.`type`, `et`.`event_id` AS `id` FROM `translations` AS `t` INNER JOIN `events_translations` AS `et` ON et.translation_id = t.id INNER JOIN `events` AS `e` ON e.id = et.event_id WHERE (t.language_id = '50') AND (e.franchise_id = '37') AND (e.is_deleted = 0) AND (e.is_active = 1)
  89. [0.22 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24175' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  90. [0.77 ms] DESCRIBE `categories`
  91. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5775' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  92. [0.49 ms] DESCRIBE `translations`
  93. [1.11 ms] SELECT `t`.`text`, `t`.`type`, `pt`.`place_id` AS `id` FROM `translations` AS `t` INNER JOIN `places_translations` AS `pt` ON pt.translation_id = t.id INNER JOIN `places` AS `p` ON p.id = pt.place_id WHERE (t.language_id = '50') AND (p.franchise_id = '37') AND (p.is_deleted = 0) AND (p.is_active = 1)
  94. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34824' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  95. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34831' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  96. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40543' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  97. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32091' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  98. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26838' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  99. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5676' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  100. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24174' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  101. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22256' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  102. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22251' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  103. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32097' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  104. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '39525' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  105. [0.19 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5682' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  106. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37206' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  107. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5703' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  108. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26323' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  109. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5884' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  110. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26839' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  111. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26310' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  112. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '30643' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  113. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5681' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  114. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5692' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  115. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5680' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  116. [0.14 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22244' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  117. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27188' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  118. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22228' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  119. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34830' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  120. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '39474' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  121. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37602' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  122. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27187' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  123. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5693' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  124. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12977' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  125. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26338' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  126. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26718' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  127. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34832' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  128. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26837' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  129. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24178' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  130. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12945' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  131. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34826' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  132. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26723' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  133. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12939' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  134. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27186' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  135. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37541' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  136. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24171' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  137. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26717' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  138. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26720' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  139. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27193' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  140. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40634' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  141. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22206' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  142. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34835' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  143. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22259' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  144. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12907' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  145. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12449' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  146. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5700' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  147. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27319' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  148. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '4589' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  149. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12759' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  150. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34827' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  151. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '35635' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  152. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26716' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  153. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27262' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  154. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26719' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  155. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32098' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  156. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26724' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  157. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '36741' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  158. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '17682' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  159. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5673' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  160. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26769' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  161. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5677' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  162. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37590' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  163. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5691' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  164. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '4573' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  165. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5716' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  166. [0.14 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5797' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  167. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24180' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  168. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26155' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  169. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32089' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  170. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32088' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  171. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26269' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  172. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37933' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  173. [0.18 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '18450' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  174. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '30644' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  175. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34828' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  176. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '36921' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  177. [0.18 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34823' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  178. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '24904' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  179. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5674' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  180. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26346' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  181. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '24747' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  182. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40636' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  183. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40637' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  184. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26255' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  185. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5873' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  186. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26715' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  187. [0.18 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26199' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  188. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40633' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  189. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37556' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  190. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27191' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  191. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37588' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  192. [0.18 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5683' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  193. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5762' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  194. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26313' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  195. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5731' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  196. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24173' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  197. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37536' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  198. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32092' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  199. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5675' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  200. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26835' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  201. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37177' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  202. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34834' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  203. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12858' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  204. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24172' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  205. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5689' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  206. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37372' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  207. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5182' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  208. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '30642' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  209. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24177' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  210. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24176' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  211. [0.19 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40635' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  212. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5764' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  213. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5684' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  214. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26336' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  215. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5749' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  216. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22224' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  217. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32090' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  218. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40632' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  219. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26114' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  220. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26721' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  221. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '25388' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  222. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37415' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  223. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '36975' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  224. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32094' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  225. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32095' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  226. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34825' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  227. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24181' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  228. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32093' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  229. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5685' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  230. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27189' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  231. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5686' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  232. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '39134' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  233. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5678' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  234. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5701' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  235. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  236. [0.15 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'More result') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  237. [0.18 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  238. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Print') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  239. [0.14 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  240. [0.14 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'E-mail') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  241. [0.14 ms] SELECT `t`.`text` FROM `translations` AS `t` INNER JOIN `franchises_translations` AS `ft` ON t.id = ft.translation_id AND ft.franchise_id = '37' WHERE (t.language_id = '50') AND (t.type = 'franchises.properties.name') LIMIT 1
  242. [0.15 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'footer') AND (parent_id IS NULL) LIMIT 1
  243. [0.15 ms] SELECT COUNT(DISTINCT d.id) AS total FROM documents d INNER JOIN documents_categories dc ON d.id = dc.document_id AND dc.category_id = '24895' WHERE d.is_deleted = 0 AND d.is_active = 1 AND d.franchise_id = '37'
  244. [0.15 ms] SELECT COUNT(DISTINCT d.id) AS total FROM documents d INNER JOIN documents_categories dc ON d.id = dc.document_id AND dc.category_id = '24892' WHERE d.is_deleted = 0 AND d.is_active = 1 AND d.franchise_id = '37'
  245. [0.16 ms] SELECT COUNT(DISTINCT d.id) AS total FROM documents d INNER JOIN documents_categories dc ON d.id = dc.document_id AND dc.category_id = '24896' WHERE d.is_deleted = 0 AND d.is_active = 1 AND d.franchise_id = '37'
  246. [0.16 ms] SELECT COUNT(DISTINCT d.id) AS total FROM documents d INNER JOIN documents_categories dc ON d.id = dc.document_id AND dc.category_id = '24897' WHERE d.is_deleted = 0 AND d.is_active = 1 AND d.franchise_id = '37'
  247. [0.16 ms] SELECT COUNT(DISTINCT d.id) AS total FROM documents d INNER JOIN documents_categories dc ON d.id = dc.document_id AND dc.category_id = '24898' WHERE d.is_deleted = 0 AND d.is_active = 1 AND d.franchise_id = '37'
  248. [0.16 ms] SELECT COUNT(DISTINCT d.id) AS total FROM documents d INNER JOIN documents_categories dc ON d.id = dc.document_id AND dc.category_id = '24899' WHERE d.is_deleted = 0 AND d.is_active = 1 AND d.franchise_id = '37'
  249. [0.17 ms] SELECT COUNT(DISTINCT d.id) AS total FROM documents d INNER JOIN documents_categories dc ON d.id = dc.document_id AND dc.category_id = '24901' WHERE d.is_deleted = 0 AND d.is_active = 1 AND d.franchise_id = '37'
  250. [0.16 ms] SELECT COUNT(DISTINCT d.id) AS total FROM documents d INNER JOIN documents_categories dc ON d.id = dc.document_id AND dc.category_id = '24902' WHERE d.is_deleted = 0 AND d.is_active = 1 AND d.franchise_id = '37'
  251. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  252. [0.14 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Partners') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  253. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  254. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Submit an Event') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  255. [0.59 ms] DESCRIBE `franchises_locations`
  256. [0.16 ms] SELECT `franchises_locations`.* FROM `franchises_locations` WHERE (is_base = 1)
  257. [1.57 ms] DESCRIBE `franchises`
  258. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '21') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  259. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '52') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  260. [0.16 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '42') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  261. [0.18 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '43') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  262. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '36') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  263. [0.95 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '1') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  264. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '54') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  265. [0.68 ms] DESCRIBE `valid_franchises_view`
  266. [0.58 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '54') ORDER BY `is_main` ASC LIMIT 1
  267. [0.18 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '35') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  268. [0.18 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '57') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  269. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '59') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  270. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '47') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  271. [0.16 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '28') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  272. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '22') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  273. [0.55 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '22') ORDER BY `is_main` ASC LIMIT 1
  274. [0.18 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '38') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  275. [0.54 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '38') ORDER BY `is_main` ASC LIMIT 1
  276. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '37') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  277. [0.55 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '37') ORDER BY `is_main` ASC LIMIT 1
  278. [0.18 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '20') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  279. [0.18 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '23') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  280. [0.54 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '23') ORDER BY `is_main` ASC LIMIT 1
  281. [0.18 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '56') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  282. [0.18 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '24') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  283. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '46') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  284. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '45') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  285. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '27') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  286. [0.55 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '27') ORDER BY `is_main` ASC LIMIT 1
  287. [0.67 ms] DESCRIBE `locations`
  288. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'continent') AND (id IN (SELECT location_id FROM franchises_locations))
  289. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '1') AND (id IN (SELECT location_id FROM franchises_locations))
  290. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'country') AND (parent_id = '1') AND (id IN (SELECT location_id FROM franchises_locations))
  291. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '176') AND (id IN (SELECT location_id FROM franchises_locations))
  292. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '367') AND (id IN (SELECT location_id FROM franchises_locations))
  293. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '179') AND (id IN (SELECT location_id FROM franchises_locations))
  294. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '337') AND (id IN (SELECT location_id FROM franchises_locations))
  295. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '387') AND (id IN (SELECT location_id FROM franchises_locations))
  296. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '582') AND (id IN (SELECT location_id FROM franchises_locations))
  297. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '639') AND (id IN (SELECT location_id FROM franchises_locations))
  298. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '641') AND (id IN (SELECT location_id FROM franchises_locations))
  299. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '642') AND (id IN (SELECT location_id FROM franchises_locations))
  300. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '215') AND (id IN (SELECT location_id FROM franchises_locations))
  301. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '216') AND (id IN (SELECT location_id FROM franchises_locations))
  302. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '2') AND (id IN (SELECT location_id FROM franchises_locations))
  303. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'country') AND (parent_id = '2') AND (id IN (SELECT location_id FROM franchises_locations))
  304. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '117') AND (id IN (SELECT location_id FROM franchises_locations))
  305. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '521') AND (id IN (SELECT location_id FROM franchises_locations))
  306. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '162') AND (id IN (SELECT location_id FROM franchises_locations))
  307. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '3') AND (id IN (SELECT location_id FROM franchises_locations))
  308. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'country') AND (parent_id = '3') AND (id IN (SELECT location_id FROM franchises_locations))
  309. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '11') AND (id IN (SELECT location_id FROM franchises_locations))
  310. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '574') AND (id IN (SELECT location_id FROM franchises_locations))
  311. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '12') AND (id IN (SELECT location_id FROM franchises_locations))
  312. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '451') AND (id IN (SELECT location_id FROM franchises_locations))
  313. [0.53 ms] DESCRIBE `partners`
  314. [0.15 ms] SELECT `partners`.* FROM `partners` WHERE (is_active = 1) AND (type = 'general-partners') AND (franchise_id = '37') LIMIT 1
  315. [0.14 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  316. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'General partner') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  317. [0.14 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  318. [0.14 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'General partner') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  319. [0.61 ms] DESCRIBE `files`
  320. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '69072') LIMIT 1
  321. [0.45 ms] DESCRIBE `franchises_locations`
  322. [0.28 ms] SELECT `franchises_locations`.* FROM `franchises_locations` WHERE (franchise_id = '37' AND is_base = 1) LIMIT 1
  323. [0.66 ms] DESCRIBE `locations`
  324. [0.15 ms] SELECT `locations`.* FROM `locations` WHERE (id = '632') AND (is_deleted = 0) LIMIT 1
  325. [0.64 ms] DESCRIBE `galleries`
  326. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22206' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  327. [0.64 ms] DESCRIBE `galleries`
  328. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22206' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  329. [0.48 ms] DESCRIBE `galleries_files`
  330. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '58533') ORDER BY `position` ASC LIMIT 1
  331. [0.56 ms] DESCRIBE `files`
  332. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '59219') AND (is_active = 1) LIMIT 1
  333. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22206' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  334. [0.21 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22224' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  335. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22224' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  336. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '58582') ORDER BY `position` ASC LIMIT 1
  337. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '59267') AND (is_active = 1) LIMIT 1
  338. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22224' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  339. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22228' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  340. [0.39 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22228' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  341. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '58595') ORDER BY `position` ASC LIMIT 1
  342. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '59279') AND (is_active = 1) LIMIT 1
  343. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22228' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  344. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22244' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  345. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22244' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  346. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '58635') ORDER BY `position` ASC LIMIT 1
  347. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '59314') AND (is_active = 1) LIMIT 1
  348. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22244' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  349. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22251' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  350. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22251' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  351. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '58649') ORDER BY `position` ASC LIMIT 1
  352. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '59327') AND (is_active = 1) LIMIT 1
  353. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22251' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  354. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22256' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  355. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22256' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  356. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '58663') ORDER BY `position` ASC LIMIT 1
  357. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '59341') AND (is_active = 1) LIMIT 1
  358. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22256' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  359. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22259' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  360. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '22259' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  361. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '58672') ORDER BY `position` ASC LIMIT 1
  362. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '59350') AND (is_active = 1) LIMIT 1
  363. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '22259' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  364. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24171' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  365. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24171' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  366. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62240') ORDER BY `position` ASC LIMIT 1
  367. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '63619') AND (is_active = 1) LIMIT 1
  368. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24171' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  369. [0.19 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24172' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  370. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24172' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  371. [0.17 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62243') ORDER BY `position` ASC LIMIT 1
  372. [0.17 ms] SELECT `files`.* FROM `files` WHERE (id = '63622') AND (is_active = 1) LIMIT 1
  373. [0.18 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24172' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  374. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24173' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  375. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24173' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  376. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62244') ORDER BY `position` ASC LIMIT 1
  377. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '63623') AND (is_active = 1) LIMIT 1
  378. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24173' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  379. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24174' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  380. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24174' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  381. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62247') ORDER BY `position` ASC LIMIT 1
  382. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '63626') AND (is_active = 1) LIMIT 1
  383. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24174' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  384. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24175' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  385. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24175' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  386. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62249') ORDER BY `position` ASC LIMIT 1
  387. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '63628') AND (is_active = 1) LIMIT 1
  388. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24175' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  389. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24176' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  390. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24176' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  391. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62252') ORDER BY `position` ASC LIMIT 1
  392. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '63633') AND (is_active = 1) LIMIT 1
  393. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24176' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  394. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24177' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  395. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24177' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  396. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62253') ORDER BY `position` ASC LIMIT 1
  397. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '63634') AND (is_active = 1) LIMIT 1
  398. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24177' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  399. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24178' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  400. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24178' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  401. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62256') ORDER BY `position` ASC LIMIT 1
  402. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '63639') AND (is_active = 1) LIMIT 1
  403. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24178' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  404. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24180' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  405. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24180' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  406. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62260') ORDER BY `position` ASC LIMIT 1
  407. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '63654') AND (is_active = 1) LIMIT 1
  408. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24180' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  409. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24181' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  410. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '24181' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  411. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '62264') ORDER BY `position` ASC LIMIT 1
  412. [0.17 ms] SELECT `files`.* FROM `files` WHERE (id = '63659') AND (is_active = 1) LIMIT 1
  413. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '24181' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  414. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26114' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  415. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26114' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  416. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26114' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  417. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26155' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  418. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26155' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  419. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26155' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  420. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26199' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  421. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26199' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  422. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '64453') ORDER BY `position` ASC LIMIT 1
  423. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '65851') AND (is_active = 1) LIMIT 1
  424. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26199' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  425. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26255' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  426. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26255' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  427. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '64509') ORDER BY `position` ASC LIMIT 1
  428. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '65905') AND (is_active = 1) LIMIT 1
  429. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26255' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  430. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26269' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  431. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26269' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  432. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '64523') ORDER BY `position` ASC LIMIT 1
  433. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '65919') AND (is_active = 1) LIMIT 1
  434. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26269' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  435. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26310' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  436. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26310' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  437. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '64564') ORDER BY `position` ASC LIMIT 1
  438. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '65958') AND (is_active = 1) LIMIT 1
  439. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26310' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  440. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26313' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  441. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26313' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  442. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '64567') ORDER BY `position` ASC LIMIT 1
  443. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '65961') AND (is_active = 1) LIMIT 1
  444. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26313' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  445. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26323' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  446. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26323' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  447. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '64577') ORDER BY `position` ASC LIMIT 1
  448. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '65971') AND (is_active = 1) LIMIT 1
  449. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26323' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  450. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26336' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  451. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26336' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  452. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '64590') ORDER BY `position` ASC LIMIT 1
  453. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '65984') AND (is_active = 1) LIMIT 1
  454. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26336' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  455. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26338' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  456. [0.19 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26338' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  457. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '64592') ORDER BY `position` ASC LIMIT 1
  458. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '65986') AND (is_active = 1) LIMIT 1
  459. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26338' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  460. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26346' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  461. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26346' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  462. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '64600') ORDER BY `position` ASC LIMIT 1
  463. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '65994') AND (is_active = 1) LIMIT 1
  464. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26346' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  465. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26715' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  466. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26715' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  467. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65123') ORDER BY `position` ASC LIMIT 1
  468. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '66799') AND (is_active = 1) LIMIT 1
  469. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26715' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  470. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26716' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  471. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26716' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  472. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65125') ORDER BY `position` ASC LIMIT 1
  473. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '66801') AND (is_active = 1) LIMIT 1
  474. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26716' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  475. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26717' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  476. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26717' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  477. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65128') ORDER BY `position` ASC LIMIT 1
  478. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '66804') AND (is_active = 1) LIMIT 1
  479. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26717' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  480. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26718' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  481. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26718' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  482. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65130') ORDER BY `position` ASC LIMIT 1
  483. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '66806') AND (is_active = 1) LIMIT 1
  484. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26718' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  485. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26719' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  486. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26719' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  487. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65133') ORDER BY `position` ASC LIMIT 1
  488. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '66809') AND (is_active = 1) LIMIT 1
  489. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26719' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  490. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26720' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  491. [0.22 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26720' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  492. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65136') ORDER BY `position` ASC LIMIT 1
  493. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '66812') AND (is_active = 1) LIMIT 1
  494. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26720' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  495. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26721' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  496. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26721' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  497. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65138') ORDER BY `position` ASC LIMIT 1
  498. [0.23 ms] SELECT `files`.* FROM `files` WHERE (id = '66814') AND (is_active = 1) LIMIT 1
  499. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26721' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  500. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26723' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  501. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26723' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  502. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65140') ORDER BY `position` ASC LIMIT 1
  503. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '66816') AND (is_active = 1) LIMIT 1
  504. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26723' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  505. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26724' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  506. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26724' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  507. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65142') ORDER BY `position` ASC LIMIT 1
  508. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '66818') AND (is_active = 1) LIMIT 1
  509. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26724' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  510. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26769' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  511. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26769' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  512. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65264') ORDER BY `position` ASC LIMIT 1
  513. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '67085') AND (is_active = 1) LIMIT 1
  514. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26769' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  515. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26835' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  516. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26835' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  517. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65386') ORDER BY `position` ASC LIMIT 1
  518. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '67223') AND (is_active = 1) LIMIT 1
  519. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26835' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  520. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26837' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  521. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26837' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  522. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65389') ORDER BY `position` ASC LIMIT 1
  523. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '67226') AND (is_active = 1) LIMIT 1
  524. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26837' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  525. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26838' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  526. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26838' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  527. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65400') ORDER BY `position` ASC LIMIT 1
  528. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '67240') AND (is_active = 1) LIMIT 1
  529. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26838' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  530. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26839' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  531. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '26839' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  532. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65404') ORDER BY `position` ASC LIMIT 1
  533. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '67244') AND (is_active = 1) LIMIT 1
  534. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '26839' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  535. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27186' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  536. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27186' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  537. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '66097') ORDER BY `position` ASC LIMIT 1
  538. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '68267') AND (is_active = 1) LIMIT 1
  539. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27186' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  540. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27187' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  541. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27187' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  542. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '66099') ORDER BY `position` ASC LIMIT 1
  543. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '68269') AND (is_active = 1) LIMIT 1
  544. [0.14 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27187' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  545. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27188' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  546. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27188' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  547. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '66100') ORDER BY `position` ASC LIMIT 1
  548. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '68270') AND (is_active = 1) LIMIT 1
  549. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27188' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  550. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27189' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  551. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27189' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  552. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '66102') ORDER BY `position` ASC LIMIT 1
  553. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '68272') AND (is_active = 1) LIMIT 1
  554. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27189' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  555. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27191' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  556. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27191' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  557. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '66104') ORDER BY `position` ASC LIMIT 1
  558. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '68274') AND (is_active = 1) LIMIT 1
  559. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27191' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  560. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27193' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  561. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27193' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  562. [0.13 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '66108') ORDER BY `position` ASC LIMIT 1
  563. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '68279') AND (is_active = 1) LIMIT 1
  564. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27193' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  565. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27262' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  566. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27262' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  567. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27262' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  568. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27319' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  569. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '27319' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  570. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '27319' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  571. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '30642' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  572. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '30642' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  573. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '72481') ORDER BY `position` ASC LIMIT 1
  574. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '75278') AND (is_active = 1) LIMIT 1
  575. [0.17 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '30642' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  576. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '30643' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  577. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '30643' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  578. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '72482') ORDER BY `position` ASC LIMIT 1
  579. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '75279') AND (is_active = 1) LIMIT 1
  580. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '30643' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  581. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '30644' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  582. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '30644' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  583. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '72483') ORDER BY `position` ASC LIMIT 1
  584. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '75280') AND (is_active = 1) LIMIT 1
  585. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '30644' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  586. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32088' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  587. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32088' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  588. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75178') ORDER BY `position` ASC LIMIT 1
  589. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '78296') AND (is_active = 1) LIMIT 1
  590. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32088' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  591. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32089' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  592. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32089' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  593. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75179') ORDER BY `position` ASC LIMIT 1
  594. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '78297') AND (is_active = 1) LIMIT 1
  595. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32089' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  596. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32090' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  597. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32090' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  598. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75180') ORDER BY `position` ASC LIMIT 1
  599. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '78298') AND (is_active = 1) LIMIT 1
  600. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32090' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  601. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32091' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  602. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32091' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  603. [0.18 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75181') ORDER BY `position` ASC LIMIT 1
  604. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '78299') AND (is_active = 1) LIMIT 1
  605. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32091' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  606. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32092' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  607. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32092' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  608. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75182') ORDER BY `position` ASC LIMIT 1
  609. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '78300') AND (is_active = 1) LIMIT 1
  610. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32092' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  611. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32093' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  612. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32093' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  613. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75183') ORDER BY `position` ASC LIMIT 1
  614. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '78301') AND (is_active = 1) LIMIT 1
  615. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32093' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  616. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32094' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  617. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32094' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  618. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75184') ORDER BY `position` ASC LIMIT 1
  619. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '78302') AND (is_active = 1) LIMIT 1
  620. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32094' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  621. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32095' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  622. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32095' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  623. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75185') ORDER BY `position` ASC LIMIT 1
  624. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '78303') AND (is_active = 1) LIMIT 1
  625. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32095' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  626. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32097' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  627. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32097' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  628. [0.13 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75188') ORDER BY `position` ASC LIMIT 1
  629. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '78305') AND (is_active = 1) LIMIT 1
  630. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32097' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  631. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32098' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  632. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '32098' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  633. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '75190') ORDER BY `position` ASC LIMIT 1
  634. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '78307') AND (is_active = 1) LIMIT 1
  635. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '32098' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  636. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34823' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  637. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34823' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  638. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78147') ORDER BY `position` ASC LIMIT 1
  639. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '81308') AND (is_active = 1) LIMIT 1
  640. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34823' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  641. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34824' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  642. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34824' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  643. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78148') ORDER BY `position` ASC LIMIT 1
  644. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '81309') AND (is_active = 1) LIMIT 1
  645. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34824' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  646. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34825' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  647. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34825' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  648. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78150') ORDER BY `position` ASC LIMIT 1
  649. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '81315') AND (is_active = 1) LIMIT 1
  650. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34825' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  651. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34826' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  652. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34826' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  653. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78151') ORDER BY `position` ASC LIMIT 1
  654. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '81316') AND (is_active = 1) LIMIT 1
  655. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34826' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  656. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34827' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  657. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34827' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  658. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78153') ORDER BY `position` ASC LIMIT 1
  659. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '81329') AND (is_active = 1) LIMIT 1
  660. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34827' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  661. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34828' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  662. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34828' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  663. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78155') ORDER BY `position` ASC LIMIT 1
  664. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '81334') AND (is_active = 1) LIMIT 1
  665. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34828' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  666. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34830' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  667. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34830' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  668. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78157') ORDER BY `position` ASC LIMIT 1
  669. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '81336') AND (is_active = 1) LIMIT 1
  670. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34830' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  671. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34831' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  672. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34831' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  673. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78159') ORDER BY `position` ASC LIMIT 1
  674. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '81350') AND (is_active = 1) LIMIT 1
  675. [0.13 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34831' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  676. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34832' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  677. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34832' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  678. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78161') ORDER BY `position` ASC LIMIT 1
  679. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '81352') AND (is_active = 1) LIMIT 1
  680. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34832' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  681. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34834' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  682. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34834' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  683. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78163') ORDER BY `position` ASC LIMIT 1
  684. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '81354') AND (is_active = 1) LIMIT 1
  685. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34834' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  686. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34835' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  687. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '34835' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  688. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '78165') ORDER BY `position` ASC LIMIT 1
  689. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '81360') AND (is_active = 1) LIMIT 1
  690. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '34835' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  691. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '35635' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  692. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '35635' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  693. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '79122') ORDER BY `position` ASC LIMIT 1
  694. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '82373') AND (is_active = 1) LIMIT 1
  695. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '35635' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  696. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '36741' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  697. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '36741' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  698. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '36741' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  699. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '36921' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  700. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '36921' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  701. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '36921' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  702. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '36975' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  703. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '36975' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  704. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '36975' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  705. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37177' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  706. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37177' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  707. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '80664') ORDER BY `position` ASC LIMIT 1
  708. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '83841') AND (is_active = 1) LIMIT 1
  709. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37177' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  710. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37206' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  711. [0.22 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37206' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  712. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '80693') ORDER BY `position` ASC LIMIT 1
  713. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '83869') AND (is_active = 1) LIMIT 1
  714. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37206' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  715. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37372' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  716. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37372' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  717. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '80859') ORDER BY `position` ASC LIMIT 1
  718. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '84027') AND (is_active = 1) LIMIT 1
  719. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37372' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  720. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37415' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  721. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37415' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  722. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '80902') ORDER BY `position` ASC LIMIT 1
  723. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '84068') AND (is_active = 1) LIMIT 1
  724. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37415' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  725. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37536' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  726. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37536' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  727. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '81023') ORDER BY `position` ASC LIMIT 1
  728. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '84181') AND (is_active = 1) LIMIT 1
  729. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37536' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  730. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37541' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  731. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37541' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  732. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '81028') ORDER BY `position` ASC LIMIT 1
  733. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '84186') AND (is_active = 1) LIMIT 1
  734. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37541' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  735. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37556' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  736. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37556' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  737. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '81043') ORDER BY `position` ASC LIMIT 1
  738. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '84200') AND (is_active = 1) LIMIT 1
  739. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37556' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  740. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37588' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  741. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37588' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  742. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '81075') ORDER BY `position` ASC LIMIT 1
  743. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '84232') AND (is_active = 1) LIMIT 1
  744. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37588' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  745. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37590' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  746. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37590' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  747. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '81077') ORDER BY `position` ASC LIMIT 1
  748. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '84234') AND (is_active = 1) LIMIT 1
  749. [0.14 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37590' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  750. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37602' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  751. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37602' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  752. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '81089') ORDER BY `position` ASC LIMIT 1
  753. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '84246') AND (is_active = 1) LIMIT 1
  754. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37602' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  755. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37921' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  756. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37921' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  757. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37921' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  758. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37933' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  759. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '37933' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  760. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '81420') ORDER BY `position` ASC LIMIT 1
  761. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '84565') AND (is_active = 1) LIMIT 1
  762. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '37933' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  763. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '39134' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  764. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '39134' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  765. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '82622') ORDER BY `position` ASC LIMIT 1
  766. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '85747') AND (is_active = 1) LIMIT 1
  767. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '39134' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  768. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '39474' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  769. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '39474' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  770. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '82962') ORDER BY `position` ASC LIMIT 1
  771. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '86087') AND (is_active = 1) LIMIT 1
  772. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '39474' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  773. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '39525' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  774. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '39525' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  775. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '83013') ORDER BY `position` ASC LIMIT 1
  776. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '86138') AND (is_active = 1) LIMIT 1
  777. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '39525' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  778. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40543' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  779. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40543' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  780. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '84246') ORDER BY `position` ASC LIMIT 1
  781. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '87584') AND (is_active = 1) LIMIT 1
  782. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40543' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  783. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40632' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  784. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40632' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  785. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '84387') ORDER BY `position` ASC LIMIT 1
  786. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '87725') AND (is_active = 1) LIMIT 1
  787. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40632' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  788. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40633' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  789. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40633' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  790. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '84388') ORDER BY `position` ASC LIMIT 1
  791. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '87726') AND (is_active = 1) LIMIT 1
  792. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40633' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  793. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40634' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  794. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40634' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  795. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '84389') ORDER BY `position` ASC LIMIT 1
  796. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '87730') AND (is_active = 1) LIMIT 1
  797. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40634' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  798. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40635' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  799. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40635' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  800. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '84390') ORDER BY `position` ASC LIMIT 1
  801. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '87731') AND (is_active = 1) LIMIT 1
  802. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40635' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  803. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40636' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  804. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40636' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  805. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '84391') ORDER BY `position` ASC LIMIT 1
  806. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '87732') AND (is_active = 1) LIMIT 1
  807. [0.16 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40636' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  808. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40637' WHERE (a.is_deleted = 0) AND (a.is_active = 1) AND (a.type = '360-photos') AND (a.franchise_id = '37') LIMIT 1
  809. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `events_galleries` AS `b` ON a.id = b.gallery_id AND b.event_id = '40637' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  810. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '84393') ORDER BY `position` ASC LIMIT 1
  811. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '87734') AND (is_active = 1) LIMIT 1
  812. [0.15 ms] SELECT `c`.* FROM `categories` AS `c` INNER JOIN `events_categories` AS `ec` ON c.id = ec.category_id AND ec.event_id = '40637' WHERE (is_active = 1) AND (is_deleted = 0) ORDER BY `parent_id` DESC LIMIT 1
  813. [0.79 ms] DESCRIBE `galleries`
  814. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '4573' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  815. [0.64 ms] DESCRIBE `galleries`
  816. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '4573' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  817. [0.46 ms] DESCRIBE `galleries_files`
  818. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '25683') ORDER BY `position` ASC LIMIT 1
  819. [0.58 ms] DESCRIBE `files`
  820. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '25141') AND (is_active = 1) LIMIT 1
  821. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '4573' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  822. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '4589' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  823. [0.18 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '4589' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  824. [0.25 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '25628') ORDER BY `position` ASC LIMIT 1
  825. [0.18 ms] SELECT `files`.* FROM `files` WHERE (id = '25152') AND (is_active = 1) LIMIT 1
  826. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '4589' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  827. [0.18 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5182' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  828. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5182' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  829. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '25689') ORDER BY `position` ASC LIMIT 1
  830. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '25157') AND (is_active = 1) LIMIT 1
  831. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5182' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  832. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5673' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  833. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5673' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  834. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '61466') ORDER BY `position` ASC LIMIT 1
  835. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '62262') AND (is_active = 1) LIMIT 1
  836. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5673' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  837. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5674' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  838. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5674' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  839. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '60325') ORDER BY `position` ASC LIMIT 1
  840. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '61020') AND (is_active = 1) LIMIT 1
  841. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5674' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  842. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5675' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  843. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5675' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  844. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '56083') ORDER BY `position` ASC LIMIT 1
  845. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '56890') AND (is_active = 1) LIMIT 1
  846. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5675' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  847. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5676' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  848. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5676' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  849. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5676' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  850. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5677' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  851. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5677' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  852. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '60327') ORDER BY `position` ASC LIMIT 1
  853. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '61023') AND (is_active = 1) LIMIT 1
  854. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5677' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  855. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5678' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  856. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5678' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  857. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '61468') ORDER BY `position` ASC LIMIT 1
  858. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '62264') AND (is_active = 1) LIMIT 1
  859. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5678' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  860. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5680' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  861. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5680' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  862. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5680' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  863. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5681' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  864. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5681' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  865. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '61903') ORDER BY `position` ASC LIMIT 1
  866. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '63086') AND (is_active = 1) LIMIT 1
  867. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5681' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  868. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5682' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  869. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5682' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  870. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '61760') ORDER BY `position` ASC LIMIT 1
  871. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '62906') AND (is_active = 1) LIMIT 1
  872. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5682' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  873. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5683' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  874. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5683' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  875. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '61905') ORDER BY `position` ASC LIMIT 1
  876. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '63088') AND (is_active = 1) LIMIT 1
  877. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5683' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  878. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5684' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  879. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5684' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  880. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65549') ORDER BY `position` ASC LIMIT 1
  881. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '67532') AND (is_active = 1) LIMIT 1
  882. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5684' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  883. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5685' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  884. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5685' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  885. [0.17 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65550') ORDER BY `position` ASC LIMIT 1
  886. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '67533') AND (is_active = 1) LIMIT 1
  887. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5685' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  888. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5686' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  889. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5686' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  890. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '65551') ORDER BY `position` ASC LIMIT 1
  891. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '67535') AND (is_active = 1) LIMIT 1
  892. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5686' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  893. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5689' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  894. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5689' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  895. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '66509') ORDER BY `position` ASC LIMIT 1
  896. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '68989') AND (is_active = 1) LIMIT 1
  897. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5689' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  898. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5691' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  899. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5691' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  900. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '66514') ORDER BY `position` ASC LIMIT 1
  901. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '69028') AND (is_active = 1) LIMIT 1
  902. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5691' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  903. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5692' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  904. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5692' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  905. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74770') ORDER BY `position` ASC LIMIT 1
  906. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '77672') AND (is_active = 1) LIMIT 1
  907. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5692' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  908. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5693' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  909. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5693' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  910. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74771') ORDER BY `position` ASC LIMIT 1
  911. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '77673') AND (is_active = 1) LIMIT 1
  912. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5693' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  913. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5700' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  914. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5700' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  915. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74772') ORDER BY `position` ASC LIMIT 1
  916. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '77675') AND (is_active = 1) LIMIT 1
  917. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5700' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  918. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5701' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  919. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5701' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  920. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74773') ORDER BY `position` ASC LIMIT 1
  921. [0.14 ms] SELECT `files`.* FROM `files` WHERE (id = '77676') AND (is_active = 1) LIMIT 1
  922. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5701' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  923. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5703' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  924. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5703' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  925. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '72487') ORDER BY `position` ASC LIMIT 1
  926. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '75284') AND (is_active = 1) LIMIT 1
  927. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5703' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  928. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5716' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  929. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5716' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  930. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74774') ORDER BY `position` ASC LIMIT 1
  931. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '77677') AND (is_active = 1) LIMIT 1
  932. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5716' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  933. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5731' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  934. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5731' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  935. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74950') ORDER BY `position` ASC LIMIT 1
  936. [0.17 ms] SELECT `files`.* FROM `files` WHERE (id = '77897') AND (is_active = 1) LIMIT 1
  937. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5731' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  938. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5749' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  939. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5749' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  940. [0.14 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74955') ORDER BY `position` ASC LIMIT 1
  941. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '77911') AND (is_active = 1) LIMIT 1
  942. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5749' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  943. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5762' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  944. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5762' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  945. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74957') ORDER BY `position` ASC LIMIT 1
  946. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '77921') AND (is_active = 1) LIMIT 1
  947. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5762' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  948. [0.18 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5764' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  949. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5764' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  950. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74961') ORDER BY `position` ASC LIMIT 1
  951. [0.16 ms] SELECT `files`.* FROM `files` WHERE (id = '77928') AND (is_active = 1) LIMIT 1
  952. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5764' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  953. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5775' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  954. [0.2 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5775' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  955. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5775' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  956. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5797' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  957. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5797' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  958. [0.15 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74965') ORDER BY `position` ASC LIMIT 1
  959. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '77938') AND (is_active = 1) LIMIT 1
  960. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5797' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  961. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5873' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  962. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5873' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  963. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5873' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  964. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5884' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  965. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '5884' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  966. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '5884' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  967. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12449' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  968. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12449' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  969. [0.16 ms] SELECT `galleries_files`.* FROM `galleries_files` WHERE (gallery_id = '74967') ORDER BY `position` ASC LIMIT 1
  970. [0.15 ms] SELECT `files`.* FROM `files` WHERE (id = '77945') AND (is_active = 1) LIMIT 1
  971. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12449' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  972. [0.17 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12759' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  973. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12759' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  974. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12759' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  975. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12858' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  976. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12858' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  977. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12858' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  978. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12907' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  979. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12907' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  980. [0.14 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12907' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  981. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12939' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  982. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12939' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  983. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12939' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  984. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12945' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  985. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12945' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  986. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12945' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  987. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12977' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  988. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '12977' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  989. [0.17 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '12977' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  990. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '17682' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  991. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '17682' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  992. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '17682' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  993. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '18450' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  994. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '18450' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  995. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '18450' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  996. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '24747' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  997. [0.16 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '24747' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  998. [0.16 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '24747' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  999. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '24904' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  1000. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '24904' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  1001. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '24904' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  1002. [0.14 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '25388' WHERE (a.is_deleted = 0) AND (a.type = '360-photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  1003. [0.15 ms] SELECT `a`.* FROM `galleries` AS `a` INNER JOIN `places_galleries` AS `b` ON a.id = b.gallery_id AND b.place_id = '25388' WHERE (a.is_deleted = 0) AND (a.type = 'photos') AND (a.franchise_id = '37') AND (a.is_active = 1) LIMIT 1
  1004. [0.15 ms] SELECT `a`.* FROM `categories` AS `a` INNER JOIN `places_categories` AS `b` ON a.id = b.category_id AND b.place_id = '25388' WHERE (a.is_deleted = 0) AND (a.franchise_id = '37') AND (a.is_active = 1) ORDER BY `a`.`parent_id` DESC LIMIT 1
  1005. [0.15 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1006. [0.15 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Back') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1007. [0.15 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1008. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'View detail') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1009. [0.15 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1010. [0.15 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'More result') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1011. [0.15 ms] SELECT `t`.`text` FROM `translations` AS `t` INNER JOIN `franchises_translations` AS `ft` ON t.id = ft.translation_id AND ft.franchise_id = '37' WHERE (t.language_id = '50') AND (t.type = 'franchises.properties.name') LIMIT 1
  1012. [0.77 ms] SHOW COLUMNS FROM campaigns WHERE Field = 'site_position'
  1013. [1.12 ms] DESCRIBE `valid_page_banners_view`
  1014. [59.32 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'wallpaper') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1015. [58.4 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'wallpaper') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1016. [58.47 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'big_banner') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1017. [58.39 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'big_banner') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1018. [58.15 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'full_banner') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1019. [61.62 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'full_banner') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1020. [64.51 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'large_rectangle') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1021. [63.43 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'large_rectangle') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1022. [62.92 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'middle_rectangle') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1023. [64.04 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'middle_rectangle') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1024. [63.21 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'half_banner_1') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1025. [63.04 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'half_banner_1') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1026. [63.04 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'half_banner_2') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1027. [63.04 ms] SELECT `valid_page_banners_view`.* FROM `valid_page_banners_view` WHERE (language_id = '50') AND (site_position = 'half_banner_2') AND (franchise_id = '37') AND (LENGTH(url) > 3) AND (LENGTH(src) > 3) AND (category_id = '24885') ORDER BY `stats_view_count` ASC, RAND() ASC LIMIT 1
  1028. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1029. [0.15 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Search') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1030. [0.14 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1031. [0.14 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'event, place, venue...') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1032. [0.14 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1033. [0.15 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Select destination') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1034. [0.56 ms] DESCRIBE `franchises_locations`
  1035. [0.15 ms] SELECT `franchises_locations`.* FROM `franchises_locations` WHERE (franchise_id = '37' AND is_base = 1) LIMIT 1
  1036. [0.61 ms] DESCRIBE `locations`
  1037. [0.14 ms] SELECT `locations`.* FROM `locations` WHERE (id = '632') AND (is_deleted = 0) LIMIT 1
  1038. [0.44 ms] DESCRIBE `franchises_locations`
  1039. [0.15 ms] SELECT `franchises_locations`.* FROM `franchises_locations` WHERE (is_base = 1)
  1040. [1.45 ms] DESCRIBE `franchises`
  1041. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '21') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1042. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '52') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1043. [0.15 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '42') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1044. [0.16 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '43') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1045. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '36') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1046. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '1') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1047. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '54') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1048. [0.65 ms] DESCRIBE `valid_franchises_view`
  1049. [0.62 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '54') ORDER BY `is_main` ASC LIMIT 1
  1050. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '35') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1051. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '57') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1052. [0.16 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '59') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1053. [0.16 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '47') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1054. [0.17 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '28') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1055. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '22') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1056. [0.75 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '22') ORDER BY `is_main` ASC LIMIT 1
  1057. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '38') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1058. [0.72 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '38') ORDER BY `is_main` ASC LIMIT 1
  1059. [0.2 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '37') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1060. [0.74 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '37') ORDER BY `is_main` ASC LIMIT 1
  1061. [0.2 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '20') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1062. [0.2 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '23') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1063. [0.77 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '23') ORDER BY `is_main` ASC LIMIT 1
  1064. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '56') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1065. [0.19 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '24') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1066. [0.21 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '46') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1067. [0.18 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '45') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1068. [0.2 ms] SELECT `franchises`.* FROM `franchises` WHERE (id = '27') AND (status = 'live') AND (is_deleted = 0) AND (is_active = 1) LIMIT 1
  1069. [0.77 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '27') ORDER BY `is_main` ASC LIMIT 1
  1070. [0.87 ms] DESCRIBE `locations`
  1071. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'continent') AND (id IN (SELECT location_id FROM franchises_locations))
  1072. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '1') AND (id IN (SELECT location_id FROM franchises_locations))
  1073. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'country') AND (parent_id = '1') AND (id IN (SELECT location_id FROM franchises_locations))
  1074. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '176') AND (id IN (SELECT location_id FROM franchises_locations))
  1075. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '367') AND (id IN (SELECT location_id FROM franchises_locations))
  1076. [0.18 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '179') AND (id IN (SELECT location_id FROM franchises_locations))
  1077. [0.18 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '337') AND (id IN (SELECT location_id FROM franchises_locations))
  1078. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '387') AND (id IN (SELECT location_id FROM franchises_locations))
  1079. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '582') AND (id IN (SELECT location_id FROM franchises_locations))
  1080. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '639') AND (id IN (SELECT location_id FROM franchises_locations))
  1081. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '641') AND (id IN (SELECT location_id FROM franchises_locations))
  1082. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '642') AND (id IN (SELECT location_id FROM franchises_locations))
  1083. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '215') AND (id IN (SELECT location_id FROM franchises_locations))
  1084. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '216') AND (id IN (SELECT location_id FROM franchises_locations))
  1085. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '2') AND (id IN (SELECT location_id FROM franchises_locations))
  1086. [0.18 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'country') AND (parent_id = '2') AND (id IN (SELECT location_id FROM franchises_locations))
  1087. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '117') AND (id IN (SELECT location_id FROM franchises_locations))
  1088. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '521') AND (id IN (SELECT location_id FROM franchises_locations))
  1089. [0.16 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '162') AND (id IN (SELECT location_id FROM franchises_locations))
  1090. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '3') AND (id IN (SELECT location_id FROM franchises_locations))
  1091. [0.18 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'country') AND (parent_id = '3') AND (id IN (SELECT location_id FROM franchises_locations))
  1092. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '11') AND (id IN (SELECT location_id FROM franchises_locations))
  1093. [0.18 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '574') AND (id IN (SELECT location_id FROM franchises_locations))
  1094. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (parent_id = '12') AND (id IN (SELECT location_id FROM franchises_locations))
  1095. [0.17 ms] SELECT `locations`.* FROM `locations` WHERE (type = 'city') AND (parent_id = '451') AND (id IN (SELECT location_id FROM franchises_locations))
  1096. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1097. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Share this page') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1098. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1099. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Language') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1100. [0.59 ms] DESCRIBE `languages`
  1101. [0.23 ms] SELECT `a`.* FROM `languages` AS `a` INNER JOIN `franchises_languages` AS `b` ON a.id = b.language_id AND b.franchise_id = '37'
  1102. [0.81 ms] DESCRIBE `valid_franchises_view`
  1103. [0.76 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '37') AND (language_id = '50') AND (domain NOT LIKE '%.worldeventscalendars.com') LIMIT 1
  1104. [0.79 ms] SELECT `valid_franchises_view`.* FROM `valid_franchises_view` WHERE (franchise_id = '37') AND (language_id = '34') AND (domain NOT LIKE '%.worldeventscalendars.com') LIMIT 1
  1105. [0.17 ms] SELECT `t`.`text` FROM `translations` AS `t` INNER JOIN `franchises_translations` AS `ft` ON t.id = ft.translation_id AND ft.franchise_id = '37' WHERE (t.language_id = '50') AND (t.type = 'franchises.properties.name') LIMIT 1
  1106. [0.17 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'events') AND (parent_id IS NULL) LIMIT 1
  1107. [0.16 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'places') AND (parent_id IS NULL) LIMIT 1
  1108. [0.17 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'venues') AND (parent_id IS NULL) LIMIT 1
  1109. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1110. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Special offers') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1111. [0.18 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'travel') AND (parent_id IS NULL) LIMIT 1
  1112. [0.2 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'map') AND (parent_id IS NULL) LIMIT 1
  1113. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1114. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Map') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1115. [0.18 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'calendar') AND (parent_id IS NULL) LIMIT 1
  1116. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1117. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Calendar') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1118. [0.16 ms] SELECT `categories`.* FROM `categories` WHERE (franchise_id = '37') AND (slug = 'multimedia') AND (parent_id IS NULL) LIMIT 1
  1119. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1120. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Send this page link') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1121. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1122. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Send this page link') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1123. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1124. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Link') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1125. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1126. [0.18 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Send') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1127. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1128. [0.16 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Your message has been sent successfully!') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1129. [0.16 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1130. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Please fill a valid email address and link to be send!') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
  1131. [0.17 ms] SELECT `t`.`text`, (select text from translations where parent_id is null and type = 'map.index' and flag = 'frontend-37' and language_id = '50' and id = t.parent_id) as original FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (parent_id IS NOT NULL) AND (language_id = '50')
  1132. [0.17 ms] SELECT `t`.* FROM `translations` AS `t` WHERE (flag = 'frontend-37') AND (type = 'map.index') AND (text = 'Please fill a valid email address and link to be send!') AND (parent_id IS NULL) AND (language_id = 50) LIMIT 1
copyright 1.12.0/5.4.13-1~dotdeb.1variables Variablestime 1376.66 msmemory 14607K of 128Mdatabase 1132 in 1103.72 ms«