| 1 | SELECT `Periode`.`id`, `Periode`.`tours_id`, `Periode`.`dated`, `Periode`.`datef`, `Periode`.`enligne`, `Periode`.`lang`, `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` FROM `cobratours`.`periodes` AS `Periode` LEFT JOIN `cobratours`.`tours` AS `Tour` ON (`Periode`.`tours_id` = `Tour`.`id`) WHERE `lang` = 'fre' AND `dated` < '2018-01-01' ORDER BY `dated` ASC | | 11 | 11 | 3 |
| 2 | SELECT `Periode`.`id`, `Periode`.`tours_id`, `Periode`.`dated`, `Periode`.`datef`, `Periode`.`enligne`, `Periode`.`lang`, `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` FROM `cobratours`.`periodes` AS `Periode` LEFT JOIN `cobratours`.`tours` AS `Tour` ON (`Periode`.`tours_id` = `Tour`.`id`) WHERE `lang` = 'fre' AND `dated` >= '2018-01-01' ORDER BY `dated` ASC | | 0 | 0 | 0 |
| 3 | SELECT `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` 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` = 'fre') 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` = 'fre') 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` = 'fre') 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` = 'fre') 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` = 'fre') 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` = 'fre') WHERE `Tour`.`id` = 48 LIMIT 1 | | 1 | 1 | 7 |
| 4 | SELECT `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` 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` = 'fre') 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` = 'fre') 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` = 'fre') 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` = 'fre') 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` = 'fre') 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` = 'fre') WHERE `Tour`.`id` = 112 LIMIT 1 | | 1 | 1 | 3 |
| 5 | SELECT `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` 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` = 'fre') 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` = 'fre') 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` = 'fre') 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` = 'fre') 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` = 'fre') 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` = 'fre') WHERE `Tour`.`id` = 29 LIMIT 1 | | 1 | 1 | 4 |
