Buscar en categorías
(default) 33 queries took 25 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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` = 'agenciacatalana' LIMIT 1111
2SELECT `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` = 'agenciacatalana' LIMIT 1110
3SELECT `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` = 'eng') 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` = 'eng') WHERE `Topic`.`slug` = 'tarragona' ORDER BY `Topic`.`order` ASC LIMIT 1111
4SELECT `TopicItem`.`id`, `TopicItem`.`topic_id`, `TopicItem`.`type`, `TopicItem`.`preferences`, `TopicItem`.`created`, `TopicItem`.`modified`, `TopicItem`.`publish`, `TopicItem`.`order`, `TopicItem`.`isotope`, `TopicItem`.`text` FROM `liquidmaps`.`topic_items` AS `TopicItem` WHERE `TopicItem`.`topic_id` = 97 AND `TopicItem`.`publish` = '1' ORDER BY `TopicItem`.`order` ASC991
5SELECT `TopicItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`topic_item_images` AS `TopicItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`TopicItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'TopicItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'eng') WHERE `TopicItemImage`.`topic_item_id` = 598 AND `TopicItemImage`.`publish` = '1' AND `TopicItemImage`.`language` IN ('all', 'eng') ORDER BY `TopicItemImage`.`order` ASC112
6SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
7SELECT `TopicItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`topic_item_images` AS `TopicItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`TopicItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'TopicItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'eng') WHERE `TopicItemImage`.`topic_item_id` = 594 AND `TopicItemImage`.`publish` = '1' AND `TopicItemImage`.`language` IN ('all', 'eng') ORDER BY `TopicItemImage`.`order` ASC112
8SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
9SELECT `TopicItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`topic_item_images` AS `TopicItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`TopicItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'TopicItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'eng') WHERE `TopicItemImage`.`topic_item_id` = 572 AND `TopicItemImage`.`publish` = '1' AND `TopicItemImage`.`language` IN ('all', 'eng') ORDER BY `TopicItemImage`.`order` ASC112
10SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
11SELECT `TopicItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`topic_item_images` AS `TopicItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`TopicItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'TopicItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'eng') WHERE `TopicItemImage`.`topic_item_id` = 596 AND `TopicItemImage`.`publish` = '1' AND `TopicItemImage`.`language` IN ('all', 'eng') ORDER BY `TopicItemImage`.`order` ASC112
12SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
13SELECT `TopicItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`topic_item_images` AS `TopicItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`TopicItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'TopicItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'eng') WHERE `TopicItemImage`.`topic_item_id` = 603 AND `TopicItemImage`.`publish` = '1' AND `TopicItemImage`.`language` IN ('all', 'eng') ORDER BY `TopicItemImage`.`order` ASC112
14SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
15SELECT `TopicItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`topic_item_images` AS `TopicItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`TopicItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'TopicItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'eng') WHERE `TopicItemImage`.`topic_item_id` = 595 AND `TopicItemImage`.`publish` = '1' AND `TopicItemImage`.`language` IN ('all', 'eng') ORDER BY `TopicItemImage`.`order` ASC112
16SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
17SELECT `TopicItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`topic_item_images` AS `TopicItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`TopicItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'TopicItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'eng') WHERE `TopicItemImage`.`topic_item_id` = 600 AND `TopicItemImage`.`publish` = '1' AND `TopicItemImage`.`language` IN ('all', 'eng') ORDER BY `TopicItemImage`.`order` ASC112
18SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
19SELECT `TopicItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`topic_item_images` AS `TopicItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`TopicItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'TopicItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'eng') WHERE `TopicItemImage`.`topic_item_id` = 601 AND `TopicItemImage`.`publish` = '1' AND `TopicItemImage`.`language` IN ('all', 'eng') ORDER BY `TopicItemImage`.`order` ASC112
20SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
21SELECT `TopicItemImage`.*, `I18n__text`.`content` FROM `liquidmaps`.`topic_item_images` AS `TopicItemImage` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__text` ON (`TopicItemImage`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'TopicItemImage' AND `I18n__text`.`field` = 'text' AND `I18n__text`.`locale` = 'eng') WHERE `TopicItemImage`.`topic_item_id` = 599 AND `TopicItemImage`.`publish` = '1' AND `TopicItemImage`.`language` IN ('all', 'eng') ORDER BY `TopicItemImage`.`order` ASC112
22SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
23SELECT `Category`.*, `I18n__title`.`content`, `I18n__tip`.`content` FROM `liquidmaps`.`categories` AS `Category` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__title` ON (`Category`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Category' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') LEFT JOIN `liquidmaps`.`i18n` AS `I18n__tip` ON (`Category`.`id` = `I18n__tip`.`foreign_key` AND `I18n__tip`.`model` = 'Category' AND `I18n__tip`.`field` = 'tip' AND `I18n__tip`.`locale` = 'eng') WHERE `Category`.`topic_id` = 97 AND `Category`.`map` = '0' AND `Category`.`parent_id` is not null ORDER BY `Category`.`parent_id` ASC, `Category`.`order` ASC441
24SELECT `Category`.*, `I18n__title`.`content`, `I18n__tip`.`content` FROM `liquidmaps`.`categories` AS `Category` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__title` ON (`Category`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Category' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') LEFT JOIN `liquidmaps`.`i18n` AS `I18n__tip` ON (`Category`.`id` = `I18n__tip`.`foreign_key` AND `I18n__tip`.`model` = 'Category' AND `I18n__tip`.`field` = 'tip' AND `I18n__tip`.`locale` = 'eng') WHERE `Category`.`topic_id` = 97 AND `Category`.`map` = '1' AND `Category`.`parent_id` is not null ORDER BY `Category`.`parent_id` ASC, `Category`.`order` ASC001
25SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
26SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
27SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
28SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
29SELECT `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` = 'eng') 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` = 'eng') WHERE `Topic`.`id` = 97 ORDER BY `Topic`.`order` ASC LIMIT 1110
30SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_NAME' LIMIT 1110
31SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`title`, `Configuration`.`value`, `Configuration`.`created`, `Configuration`.`modified` FROM `liquidmaps`.`configurations` AS `Configuration` WHERE `Configuration`.`name` = 'SITE_URL' LIMIT 1110
32SELECT `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` = 'eng') 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` = 'eng') WHERE `Topic`.`publish` = '1' AND `Topic`.`client_id` = 11 ORDER BY `Topic`.`order` ASC661
33SELECT `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` = 'eng') WHERE 1 = 1 ORDER BY `Menu`.`order` ASC221