| 1 | SELECT `Client`.*, `I18n__name`.`content` FROM `liquidmaps`.`clients` AS `Client` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__name` ON (`Client`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Client' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'en_us') WHERE `Client`.`slug` = 'crig' LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `Client`.*, `I18n__name`.`content` FROM `liquidmaps`.`clients` AS `Client` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__name` ON (`Client`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Client' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'en_us') WHERE `Client`.`slug` = 'crig' LIMIT 1 | | 1 | 1 | 0 |
| 3 | SELECT `HomeItem`.`id`, `HomeItem`.`client_id`, `HomeItem`.`type`, `HomeItem`.`created`, `HomeItem`.`modified`, `HomeItem`.`publish`, `HomeItem`.`order`, `HomeItem`.`isotope`, `HomeItem`.`text` FROM `liquidmaps`.`home_items` AS `HomeItem` WHERE `HomeItem`.`publish` = '1' AND `HomeItem`.`client_id` = 32 ORDER BY `HomeItem`.`order` ASC | | 8 | 8 | 1 |
| 4 | SELECT `HomeItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`home_item_images` AS `HomeItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`HomeItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'HomeItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'en_us') WHERE `HomeItemImage`.`home_item_id` = 1162 AND `HomeItemImage`.`publish` = '1' AND `HomeItemImage`.`language` IN ('all', NULL) ORDER BY `HomeItemImage`.`order` ASC | | 2 | 2 | 1 |
| 5 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 6 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 7 | SELECT `HomeItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`home_item_images` AS `HomeItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`HomeItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'HomeItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'en_us') WHERE `HomeItemImage`.`home_item_id` = 1159 AND `HomeItemImage`.`publish` = '1' AND `HomeItemImage`.`language` IN ('all', NULL) ORDER BY `HomeItemImage`.`order` ASC | | 2 | 2 | 1 |
| 8 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 9 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 10 | SELECT `HomeItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`home_item_images` AS `HomeItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`HomeItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'HomeItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'en_us') WHERE `HomeItemImage`.`home_item_id` = 1164 AND `HomeItemImage`.`publish` = '1' AND `HomeItemImage`.`language` IN ('all', NULL) ORDER BY `HomeItemImage`.`order` ASC | | 0 | 0 | 1 |
| 11 | SELECT `HomeItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`home_item_images` AS `HomeItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`HomeItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'HomeItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'en_us') WHERE `HomeItemImage`.`home_item_id` = 1163 AND `HomeItemImage`.`publish` = '1' AND `HomeItemImage`.`language` IN ('all', NULL) ORDER BY `HomeItemImage`.`order` ASC | | 2 | 2 | 1 |
| 12 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 13 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 14 | SELECT `HomeItemVideo`.*, `I18n__text`.`content` FROM `liquidmaps`.`home_item_videos` AS `HomeItemVideo` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`HomeItemVideo`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'HomeItemVideo' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'en_us') WHERE `HomeItemVideo`.`home_item_id` = 1161 AND `HomeItemVideo`.`publish` = '1' AND `HomeItemVideo`.`language` IN ('all', NULL) ORDER BY `HomeItemVideo`.`order` ASC | | 1 | 1 | 1 |
| 15 | SELECT `HomeItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`home_item_images` AS `HomeItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`HomeItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'HomeItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'en_us') WHERE `HomeItemImage`.`home_item_id` = 1165 AND `HomeItemImage`.`publish` = '1' AND `HomeItemImage`.`language` IN ('all', NULL) ORDER BY `HomeItemImage`.`order` ASC | | 0 | 0 | 1 |
| 16 | SELECT `HomeItemVideo`.*, `I18n__text`.`content` FROM `liquidmaps`.`home_item_videos` AS `HomeItemVideo` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`HomeItemVideo`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'HomeItemVideo' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'en_us') WHERE `HomeItemVideo`.`home_item_id` = 795 AND `HomeItemVideo`.`publish` = '1' AND `HomeItemVideo`.`language` IN ('all', NULL) ORDER BY `HomeItemVideo`.`order` ASC | | 1 | 1 | 0 |
| 17 | SELECT `HomeItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`home_item_images` AS `HomeItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`HomeItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'HomeItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'en_us') WHERE `HomeItemImage`.`home_item_id` = 793 AND `HomeItemImage`.`publish` = '1' AND `HomeItemImage`.`language` IN ('all', NULL) ORDER BY `HomeItemImage`.`order` ASC | | 2 | 2 | 1 |
| 18 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 19 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 20 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 21 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 22 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 23 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 24 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1 | | 1 | 1 | 0 |
| 25 | SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_URL' LIMIT 1 | | 1 | 1 | 0 |
| 26 | SELECT `Topic`.*, `I18n__title`.`content`, `I18n__tip`.`content` FROM `liquidmaps`.`topics` AS `Topic` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__title` ON (`Topic`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Topic' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'en_us') LEFT JOIN `liquidmaps`.`i18n` AS `I18n__tip` ON (`Topic`.`id` = `I18n__tip`.`foreign_key` AND `I18n__tip`.`model` = 'Topic' AND `I18n__tip`.`field` = 'tip' AND `I18n__tip`.`locale` = 'en_us') WHERE `Topic`.`publish` = '1' AND `Topic`.`client_id` = 32 ORDER BY `Topic`.`order` ASC | | 6 | 6 | 1 |
| 27 | SELECT `Menu`.*, `I18n__title`.`content` FROM `liquidmaps`.`menus` AS `Menu` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__title` ON (`Menu`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Menu' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'en_us') WHERE 1 = 1 ORDER BY `Menu`.`order` ASC | | 2 | 2 | 0 |
