in costruzione...

 

(default) 5 queries took 65 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Profile`.`id`, `Profile`.`name`, `Profile`.`slug`, `Profile`.`description`, `Profile`.`enligne`, (`I18n___description`.`content`) AS `Profile__i18n__description`, (`I18n___enligne`.`content`) AS `Profile__i18n__enligne` FROM `cobratours`.`profiles` AS `Profile` INNER JOIN `cobratours`.`i18n` AS `I18n___description` ON (`Profile`.`id` = `I18n___description`.`foreign_key` AND `I18n___description`.`model` = 'Profile' AND `I18n___description`.`field` = 'description' AND `I18n___description`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___enligne` ON (`Profile`.`id` = `I18n___enligne`.`foreign_key` AND `I18n___enligne`.`model` = 'Profile' AND `I18n___enligne`.`field` = 'enligne' AND `I18n___enligne`.`locale` = 'ita') WHERE `slug` = 'Avventura' LIMIT 1117
2SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `cobratours`.`medias` AS `Media` WHERE ref = "Profile" AND `Media`.`ref_id` = (16) ORDER BY `Media`.`position` ASC 111
3SELECT `_description`.`id`, `_description`.`locale`, `_description`.`model`, `_description`.`foreign_key`, `_description`.`field`, `_description`.`content` FROM `cobratours`.`i18n` AS `_description` WHERE `model` = 'Profile' AND `field` = 'description' AND `_description`.`foreign_key` = (16) 220
4SELECT `_enligne`.`id`, `_enligne`.`locale`, `_enligne`.`model`, `_enligne`.`foreign_key`, `_enligne`.`field`, `_enligne`.`content` FROM `cobratours`.`i18n` AS `_enligne` WHERE `model` = 'Profile' AND `field` = 'enligne' AND `_enligne`.`foreign_key` = (16) 220
5SELECT `Tour`.`id`, `Tour`.`legend`, `Tour`.`ref`, `Tour`.`title`, `Tour`.`description`, `Tour`.`programme`, `Tour`.`photo_description`, `Tour`.`photo_programme`, `Tour`.`file_programme`, `Tour`.`enligne`, `Tour`.`intro`, `Tour`.`profile_id`, `Tour`.`promotion`, `Tour`.`v_ete`, `Tour`.`v_ete_title`, `Tour`.`v_ete_date`, `Tour`.`v_automne`, `Tour`.`v_automne_title`, `Tour`.`v_automne_date`, `Tour`.`v_hiver`, `Tour`.`v_hiver_title`, `Tour`.`v_hiver_date`, `Tour`.`v_printemp`, `Tour`.`v_printemp_title`, `Tour`.`v_printemp_date`, (`I18n___title`.`content`) AS `Tour__i18n__title`, (`I18n___intro`.`content`) AS `Tour__i18n__intro`, (`I18n___enligne`.`content`) AS `Tour__i18n__enligne`, (`I18n___programme`.`content`) AS `Tour__i18n__programme`, (`I18n___description`.`content`) AS `Tour__i18n__description`, (`I18n___file_programme`.`content`) AS `Tour__i18n__file_programme`, `Profile`.`id`, `Profile`.`name`, `Profile`.`slug`, `Profile`.`description`, `Profile`.`enligne` FROM `cobratours`.`tours` AS `Tour` INNER JOIN `cobratours`.`i18n` AS `I18n___title` ON (`Tour`.`id` = `I18n___title`.`foreign_key` AND `I18n___title`.`model` = 'Tour' AND `I18n___title`.`field` = 'title' AND `I18n___title`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___intro` ON (`Tour`.`id` = `I18n___intro`.`foreign_key` AND `I18n___intro`.`model` = 'Tour' AND `I18n___intro`.`field` = 'intro' AND `I18n___intro`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___enligne` ON (`Tour`.`id` = `I18n___enligne`.`foreign_key` AND `I18n___enligne`.`model` = 'Tour' AND `I18n___enligne`.`field` = 'enligne' AND `I18n___enligne`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___programme` ON (`Tour`.`id` = `I18n___programme`.`foreign_key` AND `I18n___programme`.`model` = 'Tour' AND `I18n___programme`.`field` = 'programme' AND `I18n___programme`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___description` ON (`Tour`.`id` = `I18n___description`.`foreign_key` AND `I18n___description`.`model` = 'Tour' AND `I18n___description`.`field` = 'description' AND `I18n___description`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___file_programme` ON (`Tour`.`id` = `I18n___file_programme`.`foreign_key` AND `I18n___file_programme`.`model` = 'Tour' AND `I18n___file_programme`.`field` = 'file_programme' AND `I18n___file_programme`.`locale` = 'ita') LEFT JOIN `cobratours`.`profiles` AS `Profile` ON (`Tour`.`profile_id` = `Profile`.`id`) WHERE `Tour`.`profile_id` = 16 AND `I18n___enligne`.`content` = 10057