| 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` = 'liquiddinamik' LIMIT 1 | | 1 | 1 | 1 |
| 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` = 'liquiddinamik' LIMIT 1 | | 1 | 1 | 2 |
| 3 | SELECT `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`.`slug` = 'design-suggestions-to-create-your-100-customizable-pages' ORDER BY `Category`.`order` ASC LIMIT 1 | | 1 | 1 | 1 |
| 4 | SELECT `Subcategory`.*, `I18n__name`.`content` FROM `liquidmaps`.`subcategories` AS `Subcategory` LEFT JOIN `liquidmaps`.`i18n` AS `I18n__name` ON (`Subcategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Subcategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE `Subcategory`.`category_id` = 1392 AND `Subcategory`.`publish` = '1' ORDER BY `Subcategory`.`order` ASC | | 2 | 2 | 1 |
| 5 | SELECT `SubcategoriesUser`.`user_id`, `SubcategoriesUser`.`subcategory_id`, `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`order`, `Subcategory`.`name`, `Subcategory`.`isotope`, `Subcategory`.`created`, `Subcategory`.`modified`, `Subcategory`.`created_by`, `Subcategory`.`modified_by`, `Subcategory`.`publish`, `User`.`id`, `User`.`email`, `User`.`username`, `User`.`user_type`, `User`.`user_info`, `User`.`password`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`acronym`, `User`.`author`, `User`.`author_year`, `User`.`year`, `User`.`image`, `User`.`dir`, `User`.`topic_id`, `User`.`about`, `User`.`webpage`, `User`.`company_position`, `User`.`company_trade_name`, `User`.`company_cif`, `User`.`company_sector`, `User`.`company_address`, `User`.`company_population`, `User`.`company_postal_code`, `User`.`company_phone`, `User`.`company_fax`, `User`.`company_email`, `User`.`role`, `User`.`group_id`, `User`.`hash`, `User`.`enabled`, `User`.`created`, `User`.`modified`, `User`.`document`, `User`.`address`, `User`.`population`, `User`.`province`, `User`.`country_id`, `User`.`lat`, `User`.`lng`, `User`.`postal_code`, `User`.`phone`, `User`.`fax`, `User`.`profile_css`, `User`.`login_activated`, `User`.`is_vip`, `User`.`related`, `User`.`newsletter`, `User`.`measure`, `User`.`technique`, `User`.`material`, `User`.`source`, `User`.`fund`, `User`.`location`, `User`.`catalog`, `User`.`origin`, `User`.`preferences`, (CONCAT(`User`.`name`, ' (', `User`.`email`, ')')) AS `User__full_name` FROM `liquidmaps`.`subcategories_users` AS `SubcategoriesUser` LEFT JOIN `liquidmaps`.`subcategories` AS `Subcategory` ON (`SubcategoriesUser`.`subcategory_id` = `Subcategory`.`id`) LEFT JOIN `liquidmaps`.`users` AS `User` ON (`SubcategoriesUser`.`user_id` = `User`.`id`) WHERE `Subcategory_id` IN ('1021', '1022') | | 4 | 4 | 1 |
| 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 `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 |
| 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 | 1 |
| 10 | 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` = '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` = 233 ORDER BY `Topic`.`order` ASC LIMIT 1 | | 1 | 1 | 2 |
| 11 | 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 |
| 12 | 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 | 2 |
| 13 | 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` = '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` = 27 ORDER BY `Topic`.`order` ASC | | 8 | 8 | 2 |
| 14 | 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` = 'eng') WHERE 1 = 1 ORDER BY `Menu`.`order` ASC | | 2 | 2 | 1 |
