| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `iqtech`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '2f474c19dd4ce644374aff820ef33c31' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `StaffingRecruiting`.`id`, (`I18n__url`.`content`) AS `StaffingRecruiting__i18n_url` FROM `iqtech`.`staffing_recruitings` AS `StaffingRecruiting` INNER JOIN `iqtech`.`i18n` AS `I18n__url` ON (`StaffingRecruiting`.`id` = `I18n__url`.`foreign_key` AND `I18n__url`.`model` = 'StaffingRecruiting' AND `I18n__url`.`field` = 'url' AND `I18n__url`.`locale` = 'eng') WHERE `StaffingRecruiting`.`active` = 1 AND NOT (`StaffingRecruiting`.`id` = 6) | 9 | 9 | 0 | |
| SELECT (`I18n__name`.`content`) AS `Category__i18n_name`, (`I18n__slug`.`content`) AS `Category__i18n_slug` FROM `iqtech`.`categories` AS `Category` INNER JOIN `iqtech`.`i18n` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__slug` ON (`Category`.`id` = `I18n__slug`.`foreign_key` AND `I18n__slug`.`model` = 'Category' AND `I18n__slug`.`field` = 'slug' AND `I18n__slug`.`locale` = 'eng') WHERE `Category`.`active` = 1 AND `Category`.`section` = 'job_openings' | 1 | 1 | 1 | |
| SELECT `StaffingRecruiting`.`id`, `StaffingRecruiting`.`location` FROM `iqtech`.`staffing_recruitings` AS `StaffingRecruiting` WHERE `StaffingRecruiting`.`active` = 1 AND `StaffingRecruiting`.`location` IS NOT NULL GROUP BY `StaffingRecruiting`.`location` | 2 | 2 | 0 | |
| SELECT `Category`.`id`, `Category`.`section`, `Category`.`active`, `Category`.`modified`, `Category`.`created`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation`, (`I18n__slugTranslation`.`content`) AS `Category__i18n_slugTranslation` FROM `iqtech`.`categories` AS `Category` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__slugTranslation` ON (`Category`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'Category' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'eng') WHERE `I18n__slugTranslation`.`content` = 'programming' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content` FROM `iqtech`.`i18n` AS `slugTranslation` WHERE `model` = 'Category' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `StaffingRecruiting`.`id`, `StaffingRecruiting`.`category_id`, `StaffingRecruiting`.`section`, `StaffingRecruiting`.`active`, `StaffingRecruiting`.`featured`, `StaffingRecruiting`.`big_photo`, `StaffingRecruiting`.`citrix_url`, `StaffingRecruiting`.`start_date`, `StaffingRecruiting`.`location`, `StaffingRecruiting`.`modified`, `StaffingRecruiting`.`created`, (`I18n__nameTranslation`.`content`) AS `StaffingRecruiting__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `StaffingRecruiting__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `StaffingRecruiting__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `StaffingRecruiting__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaffingRecruiting__i18n_descriptionTranslation` FROM `iqtech`.`staffing_recruitings` AS `StaffingRecruiting` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaffingRecruiting`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaffingRecruiting' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`StaffingRecruiting`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'StaffingRecruiting' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`StaffingRecruiting`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'StaffingRecruiting' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`StaffingRecruiting`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'StaffingRecruiting' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaffingRecruiting`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaffingRecruiting' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaffingRecruiting`.`active` = 1 AND `I18n__subtitleTranslation`.`content` = 'part_time' AND `StaffingRecruiting`.`category_id` = 7 AND `StaffingRecruiting`.`location` = 'Stockholm, Sweden' AND `StaffingRecruiting`.`section` = 'job_opening' | 0 | 0 | 1 | maybe slow |
| SELECT `Consulting`.`id`, `Consulting`.`section`, `Consulting`.`active`, `Consulting`.`featured`, `Consulting`.`big_photo`, `Consulting`.`modified`, `Consulting`.`created`, (`I18n__nameTranslation`.`content`) AS `Consulting__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `Consulting__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `Consulting__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `Consulting__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `Consulting__i18n_descriptionTranslation` FROM `iqtech`.`consultings` AS `Consulting` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`Consulting`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Consulting' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`Consulting`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'Consulting' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`Consulting`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'Consulting' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`Consulting`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'Consulting' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`Consulting`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'Consulting' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `Consulting`.`active` = 1 AND `Consulting`.`section` = 'page' | 8 | 8 | 1 | maybe slow |
| SELECT `ConsultingPicture`.`id`, `ConsultingPicture`.`consulting_id`, `ConsultingPicture`.`title`, `ConsultingPicture`.`picture`, `ConsultingPicture`.`active`, `ConsultingPicture`.`created`, `ConsultingPicture`.`modified` FROM `iqtech`.`consulting_pictures` AS `ConsultingPicture` WHERE `ConsultingPicture`.`consulting_id` IN (8, 9, 10, 11, 12, 13, 14, 15) | 0 | 0 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'Consulting' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (8, 9, 10, 11, 12, 13, 14, 15) ORDER BY `id` ASC | 24 | 24 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'Consulting' AND `field` = 'url' AND `urlTranslation`.`foreign_key` IN (8, 9, 10, 11, 12, 13, 14, 15) ORDER BY `id` ASC | 24 | 24 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'Consulting' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` IN (8, 9, 10, 11, 12, 13, 14, 15) ORDER BY `id` ASC | 24 | 24 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'Consulting' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` IN (8, 9, 10, 11, 12, 13, 14, 15) ORDER BY `id` ASC | 24 | 24 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'Consulting' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` IN (8, 9, 10, 11, 12, 13, 14, 15) ORDER BY `id` ASC | 24 | 24 | 0 | |
| SELECT `Consulting`.`id`, `Consulting`.`section`, `Consulting`.`active`, `Consulting`.`featured`, `Consulting`.`big_photo`, `Consulting`.`modified`, `Consulting`.`created`, (`I18n__nameTranslation`.`content`) AS `Consulting__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `Consulting__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `Consulting__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `Consulting__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `Consulting__i18n_descriptionTranslation` FROM `iqtech`.`consultings` AS `Consulting` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`Consulting`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Consulting' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`Consulting`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'Consulting' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`Consulting`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'Consulting' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`Consulting`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'Consulting' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`Consulting`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'Consulting' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `Consulting`.`active` = 1 AND `Consulting`.`featured` = '1' AND `Consulting`.`section` = 'case_study' | 1 | 1 | 1 | |
| SELECT `ConsultingPicture`.`id`, `ConsultingPicture`.`consulting_id`, `ConsultingPicture`.`title`, `ConsultingPicture`.`picture`, `ConsultingPicture`.`active`, `ConsultingPicture`.`created`, `ConsultingPicture`.`modified` FROM `iqtech`.`consulting_pictures` AS `ConsultingPicture` WHERE `ConsultingPicture`.`consulting_id` = (16) | 0 | 0 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'Consulting' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (16) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'Consulting' AND `field` = 'url' AND `urlTranslation`.`foreign_key` = (16) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'Consulting' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` = (16) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'Consulting' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` = (16) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'Consulting' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` = (16) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `Outsourcing`.`id`, `Outsourcing`.`section`, `Outsourcing`.`active`, `Outsourcing`.`featured`, `Outsourcing`.`citrix_url`, `Outsourcing`.`big_photo`, `Outsourcing`.`modified`, `Outsourcing`.`created`, (`I18n__nameTranslation`.`content`) AS `Outsourcing__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `Outsourcing__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `Outsourcing__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `Outsourcing__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `Outsourcing__i18n_descriptionTranslation` FROM `iqtech`.`outsourcings` AS `Outsourcing` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`Outsourcing`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Outsourcing' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`Outsourcing`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'Outsourcing' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`Outsourcing`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'Outsourcing' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`Outsourcing`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'Outsourcing' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`Outsourcing`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'Outsourcing' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `Outsourcing`.`active` = 1 AND `Outsourcing`.`section` = 'page' | 6 | 6 | 2 | maybe slow |
| SELECT `OutsourcingPicture`.`id`, `OutsourcingPicture`.`outsourcing_id`, `OutsourcingPicture`.`title`, `OutsourcingPicture`.`picture`, `OutsourcingPicture`.`active`, `OutsourcingPicture`.`created`, `OutsourcingPicture`.`modified` FROM `iqtech`.`outsourcing_pictures` AS `OutsourcingPicture` WHERE `OutsourcingPicture`.`outsourcing_id` IN (1, 2, 3, 4, 5, 6) | 0 | 0 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 2, 3, 4, 5, 6) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'url' AND `urlTranslation`.`foreign_key` IN (1, 2, 3, 4, 5, 6) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` IN (1, 2, 3, 4, 5, 6) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` IN (1, 2, 3, 4, 5, 6) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` IN (1, 2, 3, 4, 5, 6) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `Outsourcing`.`id`, `Outsourcing`.`section`, `Outsourcing`.`active`, `Outsourcing`.`featured`, `Outsourcing`.`citrix_url`, `Outsourcing`.`big_photo`, `Outsourcing`.`modified`, `Outsourcing`.`created`, (`I18n__nameTranslation`.`content`) AS `Outsourcing__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `Outsourcing__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `Outsourcing__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `Outsourcing__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `Outsourcing__i18n_descriptionTranslation` FROM `iqtech`.`outsourcings` AS `Outsourcing` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`Outsourcing`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Outsourcing' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`Outsourcing`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'Outsourcing' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`Outsourcing`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'Outsourcing' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`Outsourcing`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'Outsourcing' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`Outsourcing`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'Outsourcing' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `Outsourcing`.`active` = 1 AND `Outsourcing`.`featured` = '1' AND `Outsourcing`.`section` = 'case_study' | 1 | 1 | 1 | |
| SELECT `OutsourcingPicture`.`id`, `OutsourcingPicture`.`outsourcing_id`, `OutsourcingPicture`.`title`, `OutsourcingPicture`.`picture`, `OutsourcingPicture`.`active`, `OutsourcingPicture`.`created`, `OutsourcingPicture`.`modified` FROM `iqtech`.`outsourcing_pictures` AS `OutsourcingPicture` WHERE `OutsourcingPicture`.`outsourcing_id` = (7) | 0 | 0 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'url' AND `urlTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'Outsourcing' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` = (7) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `Training`.`id`, `Training`.`category_id`, `Training`.`section`, `Training`.`active`, `Training`.`featured`, `Training`.`big_photo`, `Training`.`embed`, `Training`.`citrix_url`, `Training`.`start_date`, `Training`.`modified`, `Training`.`created`, (`I18n__nameTranslation`.`content`) AS `Training__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `Training__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `Training__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `Training__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `Training__i18n_descriptionTranslation` FROM `iqtech`.`trainings` AS `Training` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`Training`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Training' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`Training`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'Training' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`Training`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'Training' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`Training`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'Training' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`Training`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'Training' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `Training`.`active` = 1 AND `Training`.`section` = 'page' | 6 | 6 | 1 | maybe slow |
| SELECT `TrainingPicture`.`id`, `TrainingPicture`.`training_id`, `TrainingPicture`.`title`, `TrainingPicture`.`picture`, `TrainingPicture`.`active`, `TrainingPicture`.`created`, `TrainingPicture`.`modified` FROM `iqtech`.`training_pictures` AS `TrainingPicture` WHERE `TrainingPicture`.`training_id` IN (3, 4, 5, 6, 7, 8) | 0 | 0 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'Training' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'Training' AND `field` = 'url' AND `urlTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'Training' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'Training' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'Training' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `Training`.`id`, `Training`.`category_id`, `Training`.`section`, `Training`.`active`, `Training`.`featured`, `Training`.`big_photo`, `Training`.`embed`, `Training`.`citrix_url`, `Training`.`start_date`, `Training`.`modified`, `Training`.`created`, (`I18n__nameTranslation`.`content`) AS `Training__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `Training__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `Training__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `Training__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `Training__i18n_descriptionTranslation` FROM `iqtech`.`trainings` AS `Training` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`Training`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Training' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`Training`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'Training' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`Training`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'Training' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`Training`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'Training' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`Training`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'Training' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `Training`.`active` = 1 AND `Training`.`featured` = '1' AND `Training`.`section` = 'recorded_event' ORDER BY `Training`.`created` DESC | 1 | 1 | 2 | maybe slow |
| SELECT `TrainingPicture`.`id`, `TrainingPicture`.`training_id`, `TrainingPicture`.`title`, `TrainingPicture`.`picture`, `TrainingPicture`.`active`, `TrainingPicture`.`created`, `TrainingPicture`.`modified` FROM `iqtech`.`training_pictures` AS `TrainingPicture` WHERE `TrainingPicture`.`training_id` = (10) | 0 | 0 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'Training' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (10) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'Training' AND `field` = 'url' AND `urlTranslation`.`foreign_key` = (10) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'Training' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` = (10) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'Training' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` = (10) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'Training' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` = (10) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `StaffingRecruiting`.`id`, `StaffingRecruiting`.`category_id`, `StaffingRecruiting`.`section`, `StaffingRecruiting`.`active`, `StaffingRecruiting`.`featured`, `StaffingRecruiting`.`big_photo`, `StaffingRecruiting`.`citrix_url`, `StaffingRecruiting`.`start_date`, `StaffingRecruiting`.`location`, `StaffingRecruiting`.`modified`, `StaffingRecruiting`.`created`, (`I18n__nameTranslation`.`content`) AS `StaffingRecruiting__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `StaffingRecruiting__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `StaffingRecruiting__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `StaffingRecruiting__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaffingRecruiting__i18n_descriptionTranslation` FROM `iqtech`.`staffing_recruitings` AS `StaffingRecruiting` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaffingRecruiting`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaffingRecruiting' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`StaffingRecruiting`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'StaffingRecruiting' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`StaffingRecruiting`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'StaffingRecruiting' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`StaffingRecruiting`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'StaffingRecruiting' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaffingRecruiting`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaffingRecruiting' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaffingRecruiting`.`active` = 1 AND `StaffingRecruiting`.`section` = 'pages' | 6 | 6 | 1 | maybe slow |
| SELECT `StaffingRecruitingPicture`.`id`, `StaffingRecruitingPicture`.`staffing_recruiting_id`, `StaffingRecruitingPicture`.`title`, `StaffingRecruitingPicture`.`picture`, `StaffingRecruitingPicture`.`active`, `StaffingRecruitingPicture`.`created`, `StaffingRecruitingPicture`.`modified` FROM `iqtech`.`staffing_recruiting_pictures` AS `StaffingRecruitingPicture` WHERE `StaffingRecruitingPicture`.`staffing_recruiting_id` IN (3, 4, 5, 6, 7, 8) | 0 | 0 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'url' AND `urlTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 18 | 18 | 0 | |
| SELECT `TheCompany`.`id`, `TheCompany`.`section`, `TheCompany`.`active`, `TheCompany`.`big_photo`, `TheCompany`.`modified`, `TheCompany`.`created`, (`I18n__nameTranslation`.`content`) AS `TheCompany__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `TheCompany__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `TheCompany__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `TheCompany__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `TheCompany__i18n_descriptionTranslation` FROM `iqtech`.`the_companies` AS `TheCompany` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`TheCompany`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'TheCompany' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`TheCompany`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'TheCompany' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`TheCompany`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'TheCompany' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`TheCompany`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'TheCompany' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`TheCompany`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'TheCompany' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `TheCompany`.`active` = 1 | 3 | 3 | 1 | maybe slow |
| SELECT `TheCompanyPicture`.`id`, `TheCompanyPicture`.`the_company_id`, `TheCompanyPicture`.`title`, `TheCompanyPicture`.`picture`, `TheCompanyPicture`.`active`, `TheCompanyPicture`.`created`, `TheCompanyPicture`.`modified` FROM `iqtech`.`the_company_pictures` AS `TheCompanyPicture` WHERE `TheCompanyPicture`.`the_company_id` IN (1, 2, 3) | 0 | 0 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'TheCompany' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 2, 3) ORDER BY `id` ASC | 9 | 9 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'TheCompany' AND `field` = 'url' AND `urlTranslation`.`foreign_key` IN (1, 2, 3) ORDER BY `id` ASC | 9 | 9 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'TheCompany' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` IN (1, 2, 3) ORDER BY `id` ASC | 9 | 9 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'TheCompany' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` IN (1, 2, 3) ORDER BY `id` ASC | 9 | 9 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'TheCompany' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` IN (1, 2, 3) ORDER BY `id` ASC | 9 | 9 | 0 | |
| SELECT `StaticText`.`id`, `StaticText`.`section`, `StaticText`.`active`, `StaticText`.`big_photo`, `StaticText`.`modified`, `StaticText`.`created`, (`I18n__titleTranslation`.`content`) AS `StaticText__i18n_titleTranslation`, (`I18n__nameTranslation`.`content`) AS `StaticText__i18n_nameTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaticText__i18n_descriptionTranslation` FROM `iqtech`.`static_texts` AS `StaticText` INNER JOIN `iqtech`.`i18n` AS `I18n__titleTranslation` ON (`StaticText`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'StaticText' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaticText`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaticText' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaticText`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaticText' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaticText`.`id` = 14 AND `StaticText`.`section` = 'default' AND `StaticText`.`active` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaticText`.`id`, `StaticText`.`section`, `StaticText`.`active`, `StaticText`.`big_photo`, `StaticText`.`modified`, `StaticText`.`created`, (`I18n__titleTranslation`.`content`) AS `StaticText__i18n_titleTranslation`, (`I18n__nameTranslation`.`content`) AS `StaticText__i18n_nameTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaticText__i18n_descriptionTranslation` FROM `iqtech`.`static_texts` AS `StaticText` INNER JOIN `iqtech`.`i18n` AS `I18n__titleTranslation` ON (`StaticText`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'StaticText' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaticText`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaticText' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaticText`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaticText' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaticText`.`id` = 15 AND `StaticText`.`section` = 'default' AND `StaticText`.`active` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaticText`.`id`, `StaticText`.`section`, `StaticText`.`active`, `StaticText`.`big_photo`, `StaticText`.`modified`, `StaticText`.`created`, (`I18n__titleTranslation`.`content`) AS `StaticText__i18n_titleTranslation`, (`I18n__nameTranslation`.`content`) AS `StaticText__i18n_nameTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaticText__i18n_descriptionTranslation` FROM `iqtech`.`static_texts` AS `StaticText` INNER JOIN `iqtech`.`i18n` AS `I18n__titleTranslation` ON (`StaticText`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'StaticText' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaticText`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaticText' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaticText`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaticText' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaticText`.`id` = 16 AND `StaticText`.`section` = 'default' AND `StaticText`.`active` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaticText`.`id`, `StaticText`.`section`, `StaticText`.`active`, `StaticText`.`big_photo`, `StaticText`.`modified`, `StaticText`.`created`, (`I18n__titleTranslation`.`content`) AS `StaticText__i18n_titleTranslation`, (`I18n__nameTranslation`.`content`) AS `StaticText__i18n_nameTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaticText__i18n_descriptionTranslation` FROM `iqtech`.`static_texts` AS `StaticText` INNER JOIN `iqtech`.`i18n` AS `I18n__titleTranslation` ON (`StaticText`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'StaticText' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaticText`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaticText' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaticText`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaticText' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaticText`.`id` = 18 AND `StaticText`.`section` = 'default' AND `StaticText`.`active` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaticText`.`id`, `StaticText`.`section`, `StaticText`.`active`, `StaticText`.`big_photo`, `StaticText`.`modified`, `StaticText`.`created`, (`I18n__titleTranslation`.`content`) AS `StaticText__i18n_titleTranslation`, (`I18n__nameTranslation`.`content`) AS `StaticText__i18n_nameTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaticText__i18n_descriptionTranslation` FROM `iqtech`.`static_texts` AS `StaticText` INNER JOIN `iqtech`.`i18n` AS `I18n__titleTranslation` ON (`StaticText`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'StaticText' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaticText`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaticText' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaticText`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaticText' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaticText`.`id` = 17 AND `StaticText`.`section` = 'default' AND `StaticText`.`active` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaticText`.`id`, `StaticText`.`section`, `StaticText`.`active`, `StaticText`.`big_photo`, `StaticText`.`modified`, `StaticText`.`created`, (`I18n__titleTranslation`.`content`) AS `StaticText__i18n_titleTranslation`, (`I18n__nameTranslation`.`content`) AS `StaticText__i18n_nameTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaticText__i18n_descriptionTranslation` FROM `iqtech`.`static_texts` AS `StaticText` INNER JOIN `iqtech`.`i18n` AS `I18n__titleTranslation` ON (`StaticText`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'StaticText' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaticText`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaticText' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaticText`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaticText' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaticText`.`id` = 19 AND `StaticText`.`section` = 'default' AND `StaticText`.`active` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaticText`.`id`, `StaticText`.`section`, `StaticText`.`active`, `StaticText`.`big_photo`, `StaticText`.`modified`, `StaticText`.`created`, (`I18n__titleTranslation`.`content`) AS `StaticText__i18n_titleTranslation`, (`I18n__nameTranslation`.`content`) AS `StaticText__i18n_nameTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaticText__i18n_descriptionTranslation` FROM `iqtech`.`static_texts` AS `StaticText` INNER JOIN `iqtech`.`i18n` AS `I18n__titleTranslation` ON (`StaticText`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'StaticText' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaticText`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaticText' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaticText`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaticText' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaticText`.`id` = 20 AND `StaticText`.`section` = 'default' AND `StaticText`.`active` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaticText`.`id`, `StaticText`.`section`, `StaticText`.`active`, `StaticText`.`big_photo`, `StaticText`.`modified`, `StaticText`.`created`, (`I18n__titleTranslation`.`content`) AS `StaticText__i18n_titleTranslation`, (`I18n__nameTranslation`.`content`) AS `StaticText__i18n_nameTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaticText__i18n_descriptionTranslation` FROM `iqtech`.`static_texts` AS `StaticText` INNER JOIN `iqtech`.`i18n` AS `I18n__titleTranslation` ON (`StaticText`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'StaticText' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaticText`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaticText' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaticText`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaticText' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaticText`.`id` = 21 AND `StaticText`.`section` = 'default' AND `StaticText`.`active` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaffingRecruiting`.`id`, `StaffingRecruiting`.`category_id`, `StaffingRecruiting`.`section`, `StaffingRecruiting`.`active`, `StaffingRecruiting`.`featured`, `StaffingRecruiting`.`big_photo`, `StaffingRecruiting`.`citrix_url`, `StaffingRecruiting`.`start_date`, `StaffingRecruiting`.`location`, `StaffingRecruiting`.`modified`, `StaffingRecruiting`.`created`, (`I18n__nameTranslation`.`content`) AS `StaffingRecruiting__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `StaffingRecruiting__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `StaffingRecruiting__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `StaffingRecruiting__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaffingRecruiting__i18n_descriptionTranslation` FROM `iqtech`.`staffing_recruitings` AS `StaffingRecruiting` INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaffingRecruiting`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaffingRecruiting' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`StaffingRecruiting`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'StaffingRecruiting' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`StaffingRecruiting`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'StaffingRecruiting' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`StaffingRecruiting`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'StaffingRecruiting' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaffingRecruiting`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaffingRecruiting' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaffingRecruiting`.`active` = 1 AND `StaffingRecruiting`.`featured` = '1' AND `StaffingRecruiting`.`section` = 'job_opening' ORDER BY `StaffingRecruiting`.`created` DESC | 1 | 1 | 1 | |
| SELECT `StaffingRecruitingPicture`.`id`, `StaffingRecruitingPicture`.`staffing_recruiting_id`, `StaffingRecruitingPicture`.`title`, `StaffingRecruitingPicture`.`picture`, `StaffingRecruitingPicture`.`active`, `StaffingRecruitingPicture`.`created`, `StaffingRecruitingPicture`.`modified` FROM `iqtech`.`staffing_recruiting_pictures` AS `StaffingRecruitingPicture` WHERE `StaffingRecruitingPicture`.`staffing_recruiting_id` = (15) | 0 | 0 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'url' AND `urlTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'StaffingRecruiting' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` = (15) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `StaticText`.`id`, `StaticText`.`section`, `StaticText`.`active`, `StaticText`.`big_photo`, `StaticText`.`modified`, `StaticText`.`created`, (`I18n__titleTranslation`.`content`) AS `StaticText__i18n_titleTranslation`, (`I18n__nameTranslation`.`content`) AS `StaticText__i18n_nameTranslation`, (`I18n__descriptionTranslation`.`content`) AS `StaticText__i18n_descriptionTranslation` FROM `iqtech`.`static_texts` AS `StaticText` INNER JOIN `iqtech`.`i18n` AS `I18n__titleTranslation` ON (`StaticText`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'StaticText' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`StaticText`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'StaticText' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`StaticText`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'StaticText' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `StaticText`.`id` = 22 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaticTextPicture`.`id`, `StaticTextPicture`.`static_text_id`, `StaticTextPicture`.`title`, `StaticTextPicture`.`picture`, `StaticTextPicture`.`active`, `StaticTextPicture`.`created`, `StaticTextPicture`.`modified` FROM `iqtech`.`static_text_pictures` AS `StaticTextPicture` WHERE `StaticTextPicture`.`static_text_id` = (22) | 1 | 1 | 0 | |
| SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `iqtech`.`i18n` AS `titleTranslation` WHERE `model` = 'StaticText' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (22) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'StaticText' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (22) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'StaticText' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` = (22) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `Blog`.`id`, `Blog`.`category_id`, `Blog`.`featured`, `Blog`.`active`, `Blog`.`big_photo`, `Blog`.`views`, `Blog`.`modified`, `Blog`.`created`, (`I18n__nameTranslation`.`content`) AS `Blog__i18n_nameTranslation`, (`I18n__urlTranslation`.`content`) AS `Blog__i18n_urlTranslation`, (`I18n__pagenameTranslation`.`content`) AS `Blog__i18n_pagenameTranslation`, (`I18n__subtitleTranslation`.`content`) AS `Blog__i18n_subtitleTranslation`, (`I18n__descriptionTranslation`.`content`) AS `Blog__i18n_descriptionTranslation`, `Category`.`id`, `Category`.`section`, `Category`.`active`, `Category`.`modified`, `Category`.`created` FROM `iqtech`.`blogs` AS `Blog` LEFT JOIN `iqtech`.`categories` AS `Category` ON (`Blog`.`category_id` = `Category`.`id`) INNER JOIN `iqtech`.`i18n` AS `I18n__nameTranslation` ON (`Blog`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Blog' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__urlTranslation` ON (`Blog`.`id` = `I18n__urlTranslation`.`foreign_key` AND `I18n__urlTranslation`.`model` = 'Blog' AND `I18n__urlTranslation`.`field` = 'url' AND `I18n__urlTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__pagenameTranslation` ON (`Blog`.`id` = `I18n__pagenameTranslation`.`foreign_key` AND `I18n__pagenameTranslation`.`model` = 'Blog' AND `I18n__pagenameTranslation`.`field` = 'pagename' AND `I18n__pagenameTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__subtitleTranslation` ON (`Blog`.`id` = `I18n__subtitleTranslation`.`foreign_key` AND `I18n__subtitleTranslation`.`model` = 'Blog' AND `I18n__subtitleTranslation`.`field` = 'subtitle' AND `I18n__subtitleTranslation`.`locale` = 'eng') INNER JOIN `iqtech`.`i18n` AS `I18n__descriptionTranslation` ON (`Blog`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'Blog' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'eng') WHERE `Blog`.`active` = 1 AND `Blog`.`featured` = '1' ORDER BY `Blog`.`created` DESC LIMIT 4 | 1 | 1 | 1 | |
| SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `iqtech`.`i18n` AS `nameTranslation` WHERE `model` = 'Blog' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (3) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `urlTranslation`.`id`, `urlTranslation`.`locale`, `urlTranslation`.`model`, `urlTranslation`.`foreign_key`, `urlTranslation`.`field`, `urlTranslation`.`content` FROM `iqtech`.`i18n` AS `urlTranslation` WHERE `model` = 'Blog' AND `field` = 'url' AND `urlTranslation`.`foreign_key` = (3) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `pagenameTranslation`.`id`, `pagenameTranslation`.`locale`, `pagenameTranslation`.`model`, `pagenameTranslation`.`foreign_key`, `pagenameTranslation`.`field`, `pagenameTranslation`.`content` FROM `iqtech`.`i18n` AS `pagenameTranslation` WHERE `model` = 'Blog' AND `field` = 'pagename' AND `pagenameTranslation`.`foreign_key` = (3) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `subtitleTranslation`.`id`, `subtitleTranslation`.`locale`, `subtitleTranslation`.`model`, `subtitleTranslation`.`foreign_key`, `subtitleTranslation`.`field`, `subtitleTranslation`.`content` FROM `iqtech`.`i18n` AS `subtitleTranslation` WHERE `model` = 'Blog' AND `field` = 'subtitle' AND `subtitleTranslation`.`foreign_key` = (3) ORDER BY `id` ASC | 3 | 3 | 0 | |
| SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `iqtech`.`i18n` AS `descriptionTranslation` WHERE `model` = 'Blog' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` = (3) ORDER BY `id` ASC | 3 | 3 | 0 | |
