Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Route`.`controller`, `Route`.`action`, `Route`.`pass` FROM `forumagenti_website`.`routes` AS `Route` WHERE `Route`.`url` = 'Forum-Agenti-Milano/233/anniversario/Ordina' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`pass` FROM `forumagenti_website`.`routes` AS `Route` WHERE `url` = 'Forum-Agenti-Milano' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Fair`.`id`, `Fair`.`fair`, `Fair`.`active`, `Fair`.`created`, `Fair`.`modified`, `Fair`.`suspended`, (`I18n__fair`.`content`) AS `Fair__i18n_fair` FROM `forumagenti_website`.`fairs` AS `Fair` INNER JOIN `forumagenti_website`.`fair_translations` AS `I18n__fair` ON (`Fair`.`id` = `I18n__fair`.`foreign_key` AND `I18n__fair`.`model` = 'Fair' AND `I18n__fair`.`field` = 'fair' AND `I18n__fair`.`locale` = 'ita') WHERE `Fair`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Exhibition`.`id`, `Exhibition`.`fair_id`, `Exhibition`.`exhibition`, `Exhibition`.`exhibitionimage`, `Exhibition`.`exhibitionplan`, `Exhibition`.`startdate`, `Exhibition`.`enddate`, `Exhibition`.`datetimedetail`, `Exhibition`.`location`, `Exhibition`.`address`, `Exhibition`.`goodsgate`, `Exhibition`.`exhall`, `Exhibition`.`hoteltax`, `Exhibition`.`exhibitiontext`, `Exhibition`.`exhibitiondescr`, `Exhibition`.`exhibitionendtext`, `Exhibition`.`exhibitionenddescr`, `Exhibition`.`active`, `Exhibition`.`created`, `Exhibition`.`modified`, `Exhibition`.`directions`, `Exhibition`.`city`, `Exhibition`.`addaziende`, `Exhibition`.`exyear`, `Exhibition`.`increment`, `Exhibition`.`regional`, `Exhibition`.`european`, `Exhibition`.`isvirtual`, `Exhibition`.`weight`, `Exhibition`.`maxproducts`, `Exhibition`.`availableproducts`, `Exhibition`.`showvideosfw`, `Exhibition`.`altcosts`, `Exhibition`.`directionUrl`, `Exhibition`.`directionLabel` FROM `forumagenti_website`.`exhibitions` AS `Exhibition` WHERE `Exhibition`.`fair_id` = (1) ORDER BY `Exhibition`.`startdate` DESC | 12 | 12 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 571, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 571, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 571, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 571, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 571, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 571, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 571, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 571, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 551, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 551, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 551, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 551, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 551, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 551, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 551, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 551, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 529, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 529, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 529, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 529, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 529, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 529, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 529, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 529, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 511, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 511, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 511, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 511, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 511, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 511, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 511, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 511, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 519, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 519, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 519, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 519, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 519, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 519, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 519, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 519, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 483, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 483, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 483, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 483, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 483, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 483, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 483, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 483, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 441, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 441, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 441, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 441, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 441, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 441, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 441, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 441, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 311, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 311, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 311, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 311, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 311, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 311, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 311, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 311, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 291, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 291, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 291, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 291, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 291, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 291, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 291, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 291, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 281, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 281, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 281, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 281, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 281, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 281, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 281, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 281, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 61, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 61, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 61, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 61, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 61, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 61, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 61, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 61, city ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 1, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 1, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 1, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 1, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 1, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 1, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 1, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 1, city ] | 1 | 1 | 0 | |
SELECT `Hotel`.`id`, `Hotel`.`fair_id`, `Hotel`.`hotel`, `Hotel`.`descr`, `Hotel`.`rankstars`, `Hotel`.`rankmetro`, `Hotel`.`rankcar`, `Hotel`.`rankdistance`, `Hotel`.`descrdistance`, `Hotel`.`descrcar`, `Hotel`.`descrmetro`, `Hotel`.`address`, `Hotel`.`phone`, `Hotel`.`email`, `Hotel`.`website`, `Hotel`.`active`, `Hotel`.`orderby`, `Hotel`.`created`, `Hotel`.`modified` FROM `forumagenti_website`.`hotels` AS `Hotel` WHERE `Hotel`.`fair_id` = (1) | 5 | 5 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 11, descr ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 11, descrdistance ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 11, descrcar ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 11, descrmetro ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 21, descr ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 21, descrdistance ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 21, descrcar ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 21, descrmetro ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 31, descr ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 31, descrdistance ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 31, descrcar ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 31, descrmetro ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 33, descr ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 33, descrdistance ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 33, descrcar ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 33, descrmetro ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 35, descr ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 35, descrdistance ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 35, descrcar ] | 1 | 1 | 0 | |
SELECT content from hotel_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Hotel, ita, 35, descrmetro ] | 1 | 1 | 0 | |
SELECT content from fair_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Fair, ita, 1, fair ] | 1 | 1 | 0 | |
SELECT `Generalconvention`.`id`, `Generalconvention`.`exhibition_id`, `Generalconvention`.`conventioncontent_id`, `Generalconvention`.`landing_id`, `Generalconvention`.`startdate`, `Generalconvention`.`enddate`, `Generalconvention`.`created`, `Generalconvention`.`modified`, `Landing`.`id`, `Landing`.`name`, `Landing`.`title`, `Landing`.`randomnum`, `Landing`.`landingurl`, `Landing`.`layoutlogo`, `Landing`.`contentlogo`, `Landing`.`sidebarlogo`, `Landing`.`content`, `Landing`.`bottomcontent`, `Landing`.`media_id`, `Landing`.`created`, `Landing`.`modified`, `Exhibition`.`id`, `Exhibition`.`fair_id`, `Exhibition`.`exhibition`, `Exhibition`.`exhibitionimage`, `Exhibition`.`exhibitionplan`, `Exhibition`.`startdate`, `Exhibition`.`enddate`, `Exhibition`.`datetimedetail`, `Exhibition`.`location`, `Exhibition`.`address`, `Exhibition`.`goodsgate`, `Exhibition`.`exhall`, `Exhibition`.`hoteltax`, `Exhibition`.`exhibitiontext`, `Exhibition`.`exhibitiondescr`, `Exhibition`.`exhibitionendtext`, `Exhibition`.`exhibitionenddescr`, `Exhibition`.`active`, `Exhibition`.`created`, `Exhibition`.`modified`, `Exhibition`.`directions`, `Exhibition`.`city`, `Exhibition`.`addaziende`, `Exhibition`.`exyear`, `Exhibition`.`increment`, `Exhibition`.`regional`, `Exhibition`.`european`, `Exhibition`.`isvirtual`, `Exhibition`.`weight`, `Exhibition`.`maxproducts`, `Exhibition`.`availableproducts`, `Exhibition`.`showvideosfw`, `Exhibition`.`altcosts`, `Exhibition`.`directionUrl`, `Exhibition`.`directionLabel`, `Conventioncontent`.`id`, `Conventioncontent`.`convention`, `Conventioncontent`.`slug`, `Conventioncontent`.`email`, `Conventioncontent`.`randomnum`, `Conventioncontent`.`layoutlogo`, `Conventioncontent`.`contentlogo`, `Conventioncontent`.`sidebarlogo`, `Conventioncontent`.`convtitle`, `Conventioncontent`.`convcontent`, `Conventioncontent`.`reservationformtitle`, `Conventioncontent`.`reservationformcontent`, `Conventioncontent`.`convtype`, `Conventioncontent`.`created`, `Conventioncontent`.`modified`, `Conventioncontent`.`ID_NAZIONE`, `Conventioncontent`.`ID_REGIONE` FROM `forumagenti_website`.`generalconventions` AS `Generalconvention` LEFT JOIN `forumagenti_website`.`landings` AS `Landing` ON (`Generalconvention`.`landing_id` = `Landing`.`id`) LEFT JOIN `forumagenti_website`.`exhibitions` AS `Exhibition` ON (`Generalconvention`.`exhibition_id` = `Exhibition`.`id`) LEFT JOIN `forumagenti_website`.`conventioncontents` AS `Conventioncontent` ON (`Generalconvention`.`conventioncontent_id` = `Conventioncontent`.`id`) WHERE `Exhibition`.`fair_id` = 1 AND `Conventioncontent`.`randomnum` = 233 AND `Conventioncontent`.`slug` = 'anniversario' AND `Conventioncontent`.`convtype` = 'C' AND landing_id != 0 LIMIT 1 | 1 | 1 | 0 | |
SELECT content from landing_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Landing, ita, 415, name ] | 1 | 1 | 0 | |
SELECT content from landing_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Landing, ita, 415, title ] | 1 | 1 | 0 | |
SELECT content from landing_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Landing, ita, 415, content ] | 1 | 1 | 0 | |
SELECT content from landing_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Landing, ita, 415, bottomcontent ] | 1 | 1 | 0 | |
SELECT content from conventioncontent_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Conventioncontent, ita, 419, convtitle ] | 1 | 1 | 0 | |
SELECT content from conventioncontent_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Conventioncontent, ita, 419, convcontent ] | 1 | 1 | 0 | |
SELECT content from conventioncontent_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Conventioncontent, ita, 419, reservationformtitle ] | 1 | 1 | 0 | |
SELECT content from conventioncontent_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Conventioncontent, ita, 419, reservationformcontent ] | 1 | 1 | 0 | |
SELECT `Landing`.`id`, `Landing`.`name`, `Landing`.`title`, `Landing`.`randomnum`, `Landing`.`landingurl`, `Landing`.`layoutlogo`, `Landing`.`contentlogo`, `Landing`.`sidebarlogo`, `Landing`.`content`, `Landing`.`bottomcontent`, `Landing`.`media_id`, `Landing`.`created`, `Landing`.`modified`, (`I18n__name`.`content`) AS `Landing__i18n_name`, (`I18n__title`.`content`) AS `Landing__i18n_title`, (`I18n__content`.`content`) AS `Landing__i18n_content`, (`I18n__bottomcontent`.`content`) AS `Landing__i18n_bottomcontent` FROM `forumagenti_website`.`landings` AS `Landing` INNER JOIN `forumagenti_website`.`landing_translations` AS `I18n__name` ON (`Landing`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Landing' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`landing_translations` AS `I18n__title` ON (`Landing`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Landing' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`landing_translations` AS `I18n__content` ON (`Landing`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Landing' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`landing_translations` AS `I18n__bottomcontent` ON (`Landing`.`id` = `I18n__bottomcontent`.`foreign_key` AND `I18n__bottomcontent`.`model` = 'Landing' AND `I18n__bottomcontent`.`field` = 'bottomcontent' AND `I18n__bottomcontent`.`locale` = 'ita') WHERE `Landing`.`id` = 415 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Exhibition`.`id`, `Exhibition`.`fair_id`, `Exhibition`.`exhibition`, `Exhibition`.`exhibitionimage`, `Exhibition`.`exhibitionplan`, `Exhibition`.`startdate`, `Exhibition`.`enddate`, `Exhibition`.`datetimedetail`, `Exhibition`.`location`, `Exhibition`.`address`, `Exhibition`.`goodsgate`, `Exhibition`.`exhall`, `Exhibition`.`hoteltax`, `Exhibition`.`exhibitiontext`, `Exhibition`.`exhibitiondescr`, `Exhibition`.`exhibitionendtext`, `Exhibition`.`exhibitionenddescr`, `Exhibition`.`active`, `Exhibition`.`created`, `Exhibition`.`modified`, `Exhibition`.`directions`, `Exhibition`.`city`, `Exhibition`.`addaziende`, `Exhibition`.`exyear`, `Exhibition`.`increment`, `Exhibition`.`regional`, `Exhibition`.`european`, `Exhibition`.`isvirtual`, `Exhibition`.`weight`, `Exhibition`.`maxproducts`, `Exhibition`.`availableproducts`, `Exhibition`.`showvideosfw`, `Exhibition`.`altcosts`, `Exhibition`.`directionUrl`, `Exhibition`.`directionLabel`, (`I18n__exhibition`.`content`) AS `Exhibition__i18n_exhibition`, (`I18n__exhibitiontext`.`content`) AS `Exhibition__i18n_exhibitiontext`, (`I18n__exhibitiondescr`.`content`) AS `Exhibition__i18n_exhibitiondescr`, (`I18n__exhibitionendtext`.`content`) AS `Exhibition__i18n_exhibitionendtext`, (`I18n__exhibitionenddescr`.`content`) AS `Exhibition__i18n_exhibitionenddescr`, (`I18n__directions`.`content`) AS `Exhibition__i18n_directions`, (`I18n__city`.`content`) AS `Exhibition__i18n_city`, (`I18n__datetimedetail`.`content`) AS `Exhibition__i18n_datetimedetail` FROM `forumagenti_website`.`exhibitions` AS `Exhibition` INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibition` ON (`Exhibition`.`id` = `I18n__exhibition`.`foreign_key` AND `I18n__exhibition`.`model` = 'Exhibition' AND `I18n__exhibition`.`field` = 'exhibition' AND `I18n__exhibition`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibitiontext` ON (`Exhibition`.`id` = `I18n__exhibitiontext`.`foreign_key` AND `I18n__exhibitiontext`.`model` = 'Exhibition' AND `I18n__exhibitiontext`.`field` = 'exhibitiontext' AND `I18n__exhibitiontext`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibitiondescr` ON (`Exhibition`.`id` = `I18n__exhibitiondescr`.`foreign_key` AND `I18n__exhibitiondescr`.`model` = 'Exhibition' AND `I18n__exhibitiondescr`.`field` = 'exhibitiondescr' AND `I18n__exhibitiondescr`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibitionendtext` ON (`Exhibition`.`id` = `I18n__exhibitionendtext`.`foreign_key` AND `I18n__exhibitionendtext`.`model` = 'Exhibition' AND `I18n__exhibitionendtext`.`field` = 'exhibitionendtext' AND `I18n__exhibitionendtext`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibitionenddescr` ON (`Exhibition`.`id` = `I18n__exhibitionenddescr`.`foreign_key` AND `I18n__exhibitionenddescr`.`model` = 'Exhibition' AND `I18n__exhibitionenddescr`.`field` = 'exhibitionenddescr' AND `I18n__exhibitionenddescr`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__directions` ON (`Exhibition`.`id` = `I18n__directions`.`foreign_key` AND `I18n__directions`.`model` = 'Exhibition' AND `I18n__directions`.`field` = 'directions' AND `I18n__directions`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__city` ON (`Exhibition`.`id` = `I18n__city`.`foreign_key` AND `I18n__city`.`model` = 'Exhibition' AND `I18n__city`.`field` = 'city' AND `I18n__city`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__datetimedetail` ON (`Exhibition`.`id` = `I18n__datetimedetail`.`foreign_key` AND `I18n__datetimedetail`.`model` = 'Exhibition' AND `I18n__datetimedetail`.`field` = 'datetimedetail' AND `I18n__datetimedetail`.`locale` = 'ita') WHERE `Exhibition`.`id` = 571 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Conventioncontent`.`id`, `Conventioncontent`.`convention`, `Conventioncontent`.`slug`, `Conventioncontent`.`email`, `Conventioncontent`.`randomnum`, `Conventioncontent`.`layoutlogo`, `Conventioncontent`.`contentlogo`, `Conventioncontent`.`sidebarlogo`, `Conventioncontent`.`convtitle`, `Conventioncontent`.`convcontent`, `Conventioncontent`.`reservationformtitle`, `Conventioncontent`.`reservationformcontent`, `Conventioncontent`.`convtype`, `Conventioncontent`.`created`, `Conventioncontent`.`modified`, `Conventioncontent`.`ID_NAZIONE`, `Conventioncontent`.`ID_REGIONE`, (`I18n__convtitle`.`content`) AS `Conventioncontent__i18n_convtitle`, (`I18n__convcontent`.`content`) AS `Conventioncontent__i18n_convcontent`, (`I18n__reservationformtitle`.`content`) AS `Conventioncontent__i18n_reservationformtitle`, (`I18n__reservationformcontent`.`content`) AS `Conventioncontent__i18n_reservationformcontent` FROM `forumagenti_website`.`conventioncontents` AS `Conventioncontent` INNER JOIN `forumagenti_website`.`conventioncontent_translations` AS `I18n__convtitle` ON (`Conventioncontent`.`id` = `I18n__convtitle`.`foreign_key` AND `I18n__convtitle`.`model` = 'Conventioncontent' AND `I18n__convtitle`.`field` = 'convtitle' AND `I18n__convtitle`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`conventioncontent_translations` AS `I18n__convcontent` ON (`Conventioncontent`.`id` = `I18n__convcontent`.`foreign_key` AND `I18n__convcontent`.`model` = 'Conventioncontent' AND `I18n__convcontent`.`field` = 'convcontent' AND `I18n__convcontent`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`conventioncontent_translations` AS `I18n__reservationformtitle` ON (`Conventioncontent`.`id` = `I18n__reservationformtitle`.`foreign_key` AND `I18n__reservationformtitle`.`model` = 'Conventioncontent' AND `I18n__reservationformtitle`.`field` = 'reservationformtitle' AND `I18n__reservationformtitle`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`conventioncontent_translations` AS `I18n__reservationformcontent` ON (`Conventioncontent`.`id` = `I18n__reservationformcontent`.`foreign_key` AND `I18n__reservationformcontent`.`model` = 'Conventioncontent' AND `I18n__reservationformcontent`.`field` = 'reservationformcontent' AND `I18n__reservationformcontent`.`locale` = 'ita') WHERE `Conventioncontent`.`id` = 419 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Media`.`id`, `Media`.`exhibition_id`, `Media`.`gallery_id`, `Media`.`category_id`, `Media`.`media`, `Media`.`mediathumb`, `Media`.`featured`, `Media`.`type`, `Media`.`mediadescription`, `Media`.`longmediadescription`, `Media`.`mediatitle`, `Media`.`mediaalt`, `Media`.`created`, `Media`.`modified`, `Media`.`mediaorder`, (`I18n__mediatitle`.`content`) AS `Media__i18n_mediatitle`, (`I18n__mediaalt`.`content`) AS `Media__i18n_mediaalt`, (`I18n__mediadescription`.`content`) AS `Media__i18n_mediadescription`, (`I18n__longmediadescription`.`content`) AS `Media__i18n_longmediadescription` FROM `forumagenti_website`.`media` AS `Media` INNER JOIN `forumagenti_website`.`media_translations` AS `I18n__mediatitle` ON (`Media`.`id` = `I18n__mediatitle`.`foreign_key` AND `I18n__mediatitle`.`model` = 'Media' AND `I18n__mediatitle`.`field` = 'mediatitle' AND `I18n__mediatitle`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`media_translations` AS `I18n__mediaalt` ON (`Media`.`id` = `I18n__mediaalt`.`foreign_key` AND `I18n__mediaalt`.`model` = 'Media' AND `I18n__mediaalt`.`field` = 'mediaalt' AND `I18n__mediaalt`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`media_translations` AS `I18n__mediadescription` ON (`Media`.`id` = `I18n__mediadescription`.`foreign_key` AND `I18n__mediadescription`.`model` = 'Media' AND `I18n__mediadescription`.`field` = 'mediadescription' AND `I18n__mediadescription`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`media_translations` AS `I18n__longmediadescription` ON (`Media`.`id` = `I18n__longmediadescription`.`foreign_key` AND `I18n__longmediadescription`.`model` = 'Media' AND `I18n__longmediadescription`.`field` = 'longmediadescription' AND `I18n__longmediadescription`.`locale` = 'ita') WHERE `type` = 'video' AND `Media`.`id` = 4161 LIMIT 1 | 1 | 1 | 0 | |
SELECT content from media_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Media, ita, 4161, mediadescription ] | 1 | 1 | 0 | |
SELECT content from media_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Media, ita, 4161, longmediadescription ] | 1 | 1 | 0 | |
SELECT content from media_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Media, ita, 4161, mediatitle ] | 1 | 1 | 0 | |
SELECT content from media_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Media, ita, 4161, mediaalt ] | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`pass` FROM `forumagenti_website`.`routes` AS `Route` WHERE `url` = 'Forum-Agenti-Milano' LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `forumagenti_website`.`fairs` AS `Fair` WHERE `Fair`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Fair`.`id`, `Fair`.`fair`, `Fair`.`active`, `Fair`.`created`, `Fair`.`modified`, `Fair`.`suspended`, (`I18n__fair`.`content`) AS `Fair__i18n_fair` FROM `forumagenti_website`.`fairs` AS `Fair` INNER JOIN `forumagenti_website`.`fair_translations` AS `I18n__fair` ON (`Fair`.`id` = `I18n__fair`.`foreign_key` AND `I18n__fair`.`model` = 'Fair' AND `I18n__fair`.`field` = 'fair' AND `I18n__fair`.`locale` = 'ita') WHERE `Fair`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Lingue`.`id_lingue`, `Lingue`.`Descrizione`, `Lingue`.`Abbreviazione`, `Lingue`.`Abbreviazione_2`, `Lingue`.`Abbreviazione_3` FROM `forumagenti_website`.`lingue` AS `Lingue` WHERE `Lingue`.`Abbreviazione` = 'ita' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Exhibition`.`id`, `Exhibition`.`fair_id` FROM `forumagenti_website`.`exhibitions` AS `Exhibition` WHERE `fair_id` = 1 AND `active` = '1' ORDER BY `Exhibition`.`startdate` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Exhibition`.`id`, `Exhibition`.`fair_id`, `Exhibition`.`startdate`, `Exhibition`.`enddate`, `Exhibition`.`location`, `Exhibition`.`address`, `Exhibition`.`regional`, (`I18n__exhibition`.`content`) AS `Exhibition__i18n_exhibition`, (`I18n__city`.`content`) AS `Exhibition__i18n_city`, (`I18n__datetimedetail`.`content`) AS `Exhibition__i18n_datetimedetail` FROM `forumagenti_website`.`exhibitions` AS `Exhibition` INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibition` ON (`Exhibition`.`id` = `I18n__exhibition`.`foreign_key` AND `I18n__exhibition`.`model` = 'Exhibition' AND `I18n__exhibition`.`field` = 'exhibition' AND `I18n__exhibition`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__city` ON (`Exhibition`.`id` = `I18n__city`.`foreign_key` AND `I18n__city`.`model` = 'Exhibition' AND `I18n__city`.`field` = 'city' AND `I18n__city`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__datetimedetail` ON (`Exhibition`.`id` = `I18n__datetimedetail`.`foreign_key` AND `I18n__datetimedetail`.`model` = 'Exhibition' AND `I18n__datetimedetail`.`field` = 'datetimedetail' AND `I18n__datetimedetail`.`locale` = 'ita') WHERE `fair_id` = 1 AND `Exhibition`.`id` = 571 ORDER BY `Exhibition`.`startdate` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`onlyforconventions`, `Productforexhibition`.`id`, `Productforexhibition`.`price`, (`I18n__product`.`content`) AS `Product__i18n_product` FROM `forumagenti_website`.`products` AS `Product` JOIN `forumagenti_website`.`productforexhibitions` AS `Productforexhibition` ON (`Productforexhibition`.`product_id` = `Product`.`id`) INNER JOIN `forumagenti_website`.`product_translations` AS `I18n__product` ON (`Product`.`id` = `I18n__product`.`foreign_key` AND `I18n__product`.`model` = 'Product' AND `I18n__product`.`field` = 'product' AND `I18n__product`.`locale` = 'ita') LEFT JOIN `forumagenti_website`.`users` AS `User` ON (`Product`.`user_id` = `User`.`id`) WHERE `Productforexhibition`.`exhibition_id` = 571 | 1 | 1 | 0 | |
SELECT `Productforexhibition`.`id`, `Productforexhibition`.`product_id`, `Productforexhibition`.`productimage`, `Productforexhibition`.`productthumb`, `Productforexhibition`.`exhibition_id`, `Productforexhibition`.`price` FROM `forumagenti_website`.`productforexhibitions` AS `Productforexhibition` WHERE `Productforexhibition`.`product_id` = (1) | 24 | 24 | 0 | |
SELECT `Generalconvention`.`id`, `Generalconvention`.`exhibition_id`, `Generalconvention`.`conventioncontent_id`, `Generalconvention`.`landing_id`, `Generalconvention`.`startdate`, `Generalconvention`.`enddate`, `Generalconvention`.`created`, `Generalconvention`.`modified`, `GeneralconventionsProduct`.`id`, `GeneralconventionsProduct`.`generalconvention_id`, `GeneralconventionsProduct`.`product_id`, `GeneralconventionsProduct`.`price` FROM `forumagenti_website`.`generalconventions` AS `Generalconvention` JOIN `forumagenti_website`.`generalconventions_products` AS `GeneralconventionsProduct` ON (`GeneralconventionsProduct`.`product_id` = 1 AND `GeneralconventionsProduct`.`generalconvention_id` = `Generalconvention`.`id`) | 164 | 164 | 0 | |
SELECT `Exhibition`.`id`, `Exhibition`.`fair_id`, `Exhibition`.`exhibition`, `Exhibition`.`exhibitionimage`, `Exhibition`.`exhibitionplan`, `Exhibition`.`startdate`, `Exhibition`.`enddate`, `Exhibition`.`datetimedetail`, `Exhibition`.`location`, `Exhibition`.`address`, `Exhibition`.`goodsgate`, `Exhibition`.`exhall`, `Exhibition`.`hoteltax`, `Exhibition`.`exhibitiontext`, `Exhibition`.`exhibitiondescr`, `Exhibition`.`exhibitionendtext`, `Exhibition`.`exhibitionenddescr`, `Exhibition`.`active`, `Exhibition`.`created`, `Exhibition`.`modified`, `Exhibition`.`directions`, `Exhibition`.`city`, `Exhibition`.`addaziende`, `Exhibition`.`exyear`, `Exhibition`.`increment`, `Exhibition`.`regional`, `Exhibition`.`european`, `Exhibition`.`isvirtual`, `Exhibition`.`weight`, `Exhibition`.`maxproducts`, `Exhibition`.`availableproducts`, `Exhibition`.`showvideosfw`, `Exhibition`.`altcosts`, `Exhibition`.`directionUrl`, `Exhibition`.`directionLabel`, `ExhibitionsProduct`.`id`, `ExhibitionsProduct`.`exhibition_id`, `ExhibitionsProduct`.`product_id`, `ExhibitionsProduct`.`price` FROM `forumagenti_website`.`exhibitions` AS `Exhibition` JOIN `forumagenti_website`.`exhibitions_products` AS `ExhibitionsProduct` ON (`ExhibitionsProduct`.`product_id` = 1 AND `ExhibitionsProduct`.`exhibition_id` = `Exhibition`.`id`) | 0 | 0 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 1, product ] | 1 | 1 | 0 | |
SELECT `Generalconvention`.`id`, `Generalconvention`.`exhibition_id`, `Generalconvention`.`conventioncontent_id`, `Generalconvention`.`landing_id`, `Generalconvention`.`startdate`, `Generalconvention`.`enddate`, `Generalconvention`.`created`, `Generalconvention`.`modified`, `Landing`.`id`, `Landing`.`name`, `Landing`.`title`, `Landing`.`randomnum`, `Landing`.`landingurl`, `Landing`.`layoutlogo`, `Landing`.`contentlogo`, `Landing`.`sidebarlogo`, `Landing`.`content`, `Landing`.`bottomcontent`, `Landing`.`media_id`, `Landing`.`created`, `Landing`.`modified`, `Exhibition`.`id`, `Exhibition`.`fair_id`, `Exhibition`.`exhibition`, `Exhibition`.`exhibitionimage`, `Exhibition`.`exhibitionplan`, `Exhibition`.`startdate`, `Exhibition`.`enddate`, `Exhibition`.`datetimedetail`, `Exhibition`.`location`, `Exhibition`.`address`, `Exhibition`.`goodsgate`, `Exhibition`.`exhall`, `Exhibition`.`hoteltax`, `Exhibition`.`exhibitiontext`, `Exhibition`.`exhibitiondescr`, `Exhibition`.`exhibitionendtext`, `Exhibition`.`exhibitionenddescr`, `Exhibition`.`active`, `Exhibition`.`created`, `Exhibition`.`modified`, `Exhibition`.`directions`, `Exhibition`.`city`, `Exhibition`.`addaziende`, `Exhibition`.`exyear`, `Exhibition`.`increment`, `Exhibition`.`regional`, `Exhibition`.`european`, `Exhibition`.`isvirtual`, `Exhibition`.`weight`, `Exhibition`.`maxproducts`, `Exhibition`.`availableproducts`, `Exhibition`.`showvideosfw`, `Exhibition`.`altcosts`, `Exhibition`.`directionUrl`, `Exhibition`.`directionLabel`, `Conventioncontent`.`id`, `Conventioncontent`.`convention`, `Conventioncontent`.`slug`, `Conventioncontent`.`email`, `Conventioncontent`.`randomnum`, `Conventioncontent`.`layoutlogo`, `Conventioncontent`.`contentlogo`, `Conventioncontent`.`sidebarlogo`, `Conventioncontent`.`convtitle`, `Conventioncontent`.`convcontent`, `Conventioncontent`.`reservationformtitle`, `Conventioncontent`.`reservationformcontent`, `Conventioncontent`.`convtype`, `Conventioncontent`.`created`, `Conventioncontent`.`modified`, `Conventioncontent`.`ID_NAZIONE`, `Conventioncontent`.`ID_REGIONE` FROM `forumagenti_website`.`generalconventions` AS `Generalconvention` LEFT JOIN `forumagenti_website`.`landings` AS `Landing` ON (`Generalconvention`.`landing_id` = `Landing`.`id`) LEFT JOIN `forumagenti_website`.`exhibitions` AS `Exhibition` ON (`Generalconvention`.`exhibition_id` = `Exhibition`.`id`) LEFT JOIN `forumagenti_website`.`conventioncontents` AS `Conventioncontent` ON (`Generalconvention`.`conventioncontent_id` = `Conventioncontent`.`id` AND `Conventioncontent`.`slug` = 'anniversario') WHERE `Exhibition`.`fair_id` = 1 AND `Exhibition`.`id` = 571 AND `Conventioncontent`.`slug` = 'anniversario' AND `Conventioncontent`.`convtype` = 'C' | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`product`, `GeneralconventionsProduct`.`id`, `GeneralconventionsProduct`.`generalconvention_id`, `GeneralconventionsProduct`.`product_id`, `GeneralconventionsProduct`.`price` FROM `forumagenti_website`.`products` AS `Product` JOIN `forumagenti_website`.`generalconventions_products` AS `GeneralconventionsProduct` ON (`GeneralconventionsProduct`.`generalconvention_id` = 1091 AND `GeneralconventionsProduct`.`product_id` = `Product`.`id`) | 10 | 10 | 0 | |
SELECT `Productforexhibition`.`id`, `Productforexhibition`.`product_id`, `Productforexhibition`.`exhibition_id`, `Productforexhibition`.`price` FROM `forumagenti_website`.`productforexhibitions` AS `Productforexhibition` WHERE `Productforexhibition`.`exhibition_id` = 571 AND `Productforexhibition`.`product_id` IN (43, 1, 51, 49, 47, 45, 11, 41, 21, 31) | 1 | 1 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 43, product ] | 1 | 1 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 51, product ] | 1 | 1 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 49, product ] | 1 | 1 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 47, product ] | 1 | 1 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 45, product ] | 1 | 1 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 11, product ] | 1 | 1 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 41, product ] | 1 | 1 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 21, product ] | 1 | 1 | 0 | |
SELECT content from product_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Product, ita, 31, product ] | 1 | 1 | 0 | |
SELECT `Landing`.`id`, `Landing`.`name`, `Landing`.`title`, `Landing`.`randomnum`, `Landing`.`landingurl`, `Landing`.`layoutlogo`, `Landing`.`contentlogo`, `Landing`.`sidebarlogo`, `Landing`.`content`, `Landing`.`bottomcontent`, `Landing`.`media_id`, `Landing`.`created`, `Landing`.`modified`, (`I18n__name`.`content`) AS `Landing__i18n_name`, (`I18n__title`.`content`) AS `Landing__i18n_title`, (`I18n__content`.`content`) AS `Landing__i18n_content`, (`I18n__bottomcontent`.`content`) AS `Landing__i18n_bottomcontent` FROM `forumagenti_website`.`landings` AS `Landing` INNER JOIN `forumagenti_website`.`landing_translations` AS `I18n__name` ON (`Landing`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Landing' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`landing_translations` AS `I18n__title` ON (`Landing`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Landing' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`landing_translations` AS `I18n__content` ON (`Landing`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Landing' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`landing_translations` AS `I18n__bottomcontent` ON (`Landing`.`id` = `I18n__bottomcontent`.`foreign_key` AND `I18n__bottomcontent`.`model` = 'Landing' AND `I18n__bottomcontent`.`field` = 'bottomcontent' AND `I18n__bottomcontent`.`locale` = 'ita') WHERE `Landing`.`id` = 415 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Exhibition`.`id`, `Exhibition`.`fair_id`, `Exhibition`.`exhibition`, `Exhibition`.`exhibitionimage`, `Exhibition`.`exhibitionplan`, `Exhibition`.`startdate`, `Exhibition`.`enddate`, `Exhibition`.`datetimedetail`, `Exhibition`.`location`, `Exhibition`.`address`, `Exhibition`.`goodsgate`, `Exhibition`.`exhall`, `Exhibition`.`hoteltax`, `Exhibition`.`exhibitiontext`, `Exhibition`.`exhibitiondescr`, `Exhibition`.`exhibitionendtext`, `Exhibition`.`exhibitionenddescr`, `Exhibition`.`active`, `Exhibition`.`created`, `Exhibition`.`modified`, `Exhibition`.`directions`, `Exhibition`.`city`, `Exhibition`.`addaziende`, `Exhibition`.`exyear`, `Exhibition`.`increment`, `Exhibition`.`regional`, `Exhibition`.`european`, `Exhibition`.`isvirtual`, `Exhibition`.`weight`, `Exhibition`.`maxproducts`, `Exhibition`.`availableproducts`, `Exhibition`.`showvideosfw`, `Exhibition`.`altcosts`, `Exhibition`.`directionUrl`, `Exhibition`.`directionLabel`, (`I18n__exhibition`.`content`) AS `Exhibition__i18n_exhibition`, (`I18n__exhibitiontext`.`content`) AS `Exhibition__i18n_exhibitiontext`, (`I18n__exhibitiondescr`.`content`) AS `Exhibition__i18n_exhibitiondescr`, (`I18n__exhibitionendtext`.`content`) AS `Exhibition__i18n_exhibitionendtext`, (`I18n__exhibitionenddescr`.`content`) AS `Exhibition__i18n_exhibitionenddescr`, (`I18n__directions`.`content`) AS `Exhibition__i18n_directions`, (`I18n__city`.`content`) AS `Exhibition__i18n_city`, (`I18n__datetimedetail`.`content`) AS `Exhibition__i18n_datetimedetail` FROM `forumagenti_website`.`exhibitions` AS `Exhibition` INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibition` ON (`Exhibition`.`id` = `I18n__exhibition`.`foreign_key` AND `I18n__exhibition`.`model` = 'Exhibition' AND `I18n__exhibition`.`field` = 'exhibition' AND `I18n__exhibition`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibitiontext` ON (`Exhibition`.`id` = `I18n__exhibitiontext`.`foreign_key` AND `I18n__exhibitiontext`.`model` = 'Exhibition' AND `I18n__exhibitiontext`.`field` = 'exhibitiontext' AND `I18n__exhibitiontext`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibitiondescr` ON (`Exhibition`.`id` = `I18n__exhibitiondescr`.`foreign_key` AND `I18n__exhibitiondescr`.`model` = 'Exhibition' AND `I18n__exhibitiondescr`.`field` = 'exhibitiondescr' AND `I18n__exhibitiondescr`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibitionendtext` ON (`Exhibition`.`id` = `I18n__exhibitionendtext`.`foreign_key` AND `I18n__exhibitionendtext`.`model` = 'Exhibition' AND `I18n__exhibitionendtext`.`field` = 'exhibitionendtext' AND `I18n__exhibitionendtext`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__exhibitionenddescr` ON (`Exhibition`.`id` = `I18n__exhibitionenddescr`.`foreign_key` AND `I18n__exhibitionenddescr`.`model` = 'Exhibition' AND `I18n__exhibitionenddescr`.`field` = 'exhibitionenddescr' AND `I18n__exhibitionenddescr`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__directions` ON (`Exhibition`.`id` = `I18n__directions`.`foreign_key` AND `I18n__directions`.`model` = 'Exhibition' AND `I18n__directions`.`field` = 'directions' AND `I18n__directions`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__city` ON (`Exhibition`.`id` = `I18n__city`.`foreign_key` AND `I18n__city`.`model` = 'Exhibition' AND `I18n__city`.`field` = 'city' AND `I18n__city`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`exhibition_translations` AS `I18n__datetimedetail` ON (`Exhibition`.`id` = `I18n__datetimedetail`.`foreign_key` AND `I18n__datetimedetail`.`model` = 'Exhibition' AND `I18n__datetimedetail`.`field` = 'datetimedetail' AND `I18n__datetimedetail`.`locale` = 'ita') WHERE `Exhibition`.`id` = 571 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Conventioncontent`.`id`, `Conventioncontent`.`convention`, `Conventioncontent`.`slug`, `Conventioncontent`.`email`, `Conventioncontent`.`randomnum`, `Conventioncontent`.`layoutlogo`, `Conventioncontent`.`contentlogo`, `Conventioncontent`.`sidebarlogo`, `Conventioncontent`.`convtitle`, `Conventioncontent`.`convcontent`, `Conventioncontent`.`reservationformtitle`, `Conventioncontent`.`reservationformcontent`, `Conventioncontent`.`convtype`, `Conventioncontent`.`created`, `Conventioncontent`.`modified`, `Conventioncontent`.`ID_NAZIONE`, `Conventioncontent`.`ID_REGIONE`, (`I18n__convtitle`.`content`) AS `Conventioncontent__i18n_convtitle`, (`I18n__convcontent`.`content`) AS `Conventioncontent__i18n_convcontent`, (`I18n__reservationformtitle`.`content`) AS `Conventioncontent__i18n_reservationformtitle`, (`I18n__reservationformcontent`.`content`) AS `Conventioncontent__i18n_reservationformcontent` FROM `forumagenti_website`.`conventioncontents` AS `Conventioncontent` INNER JOIN `forumagenti_website`.`conventioncontent_translations` AS `I18n__convtitle` ON (`Conventioncontent`.`id` = `I18n__convtitle`.`foreign_key` AND `I18n__convtitle`.`model` = 'Conventioncontent' AND `I18n__convtitle`.`field` = 'convtitle' AND `I18n__convtitle`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`conventioncontent_translations` AS `I18n__convcontent` ON (`Conventioncontent`.`id` = `I18n__convcontent`.`foreign_key` AND `I18n__convcontent`.`model` = 'Conventioncontent' AND `I18n__convcontent`.`field` = 'convcontent' AND `I18n__convcontent`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`conventioncontent_translations` AS `I18n__reservationformtitle` ON (`Conventioncontent`.`id` = `I18n__reservationformtitle`.`foreign_key` AND `I18n__reservationformtitle`.`model` = 'Conventioncontent' AND `I18n__reservationformtitle`.`field` = 'reservationformtitle' AND `I18n__reservationformtitle`.`locale` = 'ita') INNER JOIN `forumagenti_website`.`conventioncontent_translations` AS `I18n__reservationformcontent` ON (`Conventioncontent`.`id` = `I18n__reservationformcontent`.`foreign_key` AND `I18n__reservationformcontent`.`model` = 'Conventioncontent' AND `I18n__reservationformcontent`.`field` = 'reservationformcontent' AND `I18n__reservationformcontent`.`locale` = 'ita') WHERE `Conventioncontent`.`id` = 419 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`url` FROM `forumagenti_website`.`routes` AS `Route` WHERE `controller` = 'toolbar_access' AND `action` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`url` FROM `forumagenti_website`.`routes` AS `Route` WHERE `controller` = 'toolbar_access' AND `action` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`url` FROM `forumagenti_website`.`routes` AS `Route` WHERE `controller` = 'toolbar_access' AND `action` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`url` FROM `forumagenti_website`.`routes` AS `Route` WHERE `controller` = 'toolbar_access' AND `action` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`url` FROM `forumagenti_website`.`routes` AS `Route` WHERE `controller` = 'toolbar_access' AND `action` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`url` FROM `forumagenti_website`.`routes` AS `Route` WHERE `controller` = 'toolbar_access' AND `action` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`url` FROM `forumagenti_website`.`routes` AS `Route` WHERE `controller` = 'toolbar_access' AND `action` = '0' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`url` FROM `forumagenti_website`.`routes` AS `Route` WHERE `controller` = 'toolbar_access' AND `action` = '0' LIMIT 1 | 0 | 0 | 0 | |