Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Route`.`controller`, `Route`.`action`, `Route`.`pass` FROM `forumagenti_website`.`routes` AS `Route` WHERE `Route`.`url` = '617/special/simply-biz' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Landing`.`layoutlogo`, `Landing`.`contentlogo`, `Landing`.`sidebarlogo`, `Landing`.`media_id`, (`I18n__name`.`content`) AS `Landing__i18n_name`, (`I18n__title`.`content`) AS `Landing__i18n_title` 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') WHERE `Landing`.`randomnum` = 617 AND `Landing`.`landingurl` = 'simply-biz' 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 `Dynamicmenu`.`id` FROM `forumagenti_website`.`dynamicmenus` AS `Dynamicmenu` WHERE `dynamicmenu` = 'landing-menu' LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `forumagenti_website`.`dynamicmenus` AS `Dynamicmenu` WHERE `Dynamicmenu`.`id` = 292 | 1 | 1 | 0 | |
SELECT `Dynamicmenu`.`id`, `Dynamicmenu`.`dynamicmenu` FROM `forumagenti_website`.`dynamicmenus` AS `Dynamicmenu` WHERE `Dynamicmenu`.`id` = 292 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`labelurl`, `Route`.`controller`, `Route`.`action`, `Route`.`pass`, `Route`.`url`, `DynamicmenusRoute`.`id`, `DynamicmenusRoute`.`dynamicmenu_id`, `DynamicmenusRoute`.`route_id`, `DynamicmenusRoute`.`order`, `DynamicmenusRoute`.`parent_id`, `DynamicmenusRoute`.`active`, `DynamicmenusRoute`.`visible` FROM `forumagenti_website`.`routes` AS `Route` JOIN `forumagenti_website`.`dynamicmenus_routes` AS `DynamicmenusRoute` ON (`DynamicmenusRoute`.`dynamicmenu_id` = 292 AND `DynamicmenusRoute`.`route_id` = `Route`.`id`) WHERE `DynamicmenusRoute`.`parent_id` = 0 ORDER BY `DynamicmenusRoute`.`order` ASC | 3 | 3 | 0 | |
SELECT `Route`.`id`, `Route`.`controller`, `Route`.`action`, `Route`.`url`, `Route`.`pass` FROM `forumagenti_website`.`routes` AS `Route` WHERE `Route`.`controller` = 'fairs' AND `Route`.`action` = 'home' ORDER BY `Route`.`id` ASC | 52 | 52 | 0 | |
SELECT `Fair`.`id`, `Fair`.`fair`, `Fair`.`active`, `Fair`.`created`, `Fair`.`modified`, `Fair`.`suspended`, (`I18n__fair__ita`.`content`) AS `Fair__i18n_fair_ita` FROM `forumagenti_website`.`fairs` AS `Fair` LEFT JOIN `forumagenti_website`.`fair_translations` AS `I18n__fair__ita` ON (`Fair`.`id` = `I18n__fair__ita`.`foreign_key` AND `I18n__fair__ita`.`model` = 'Fair' AND `I18n__fair__ita`.`field` = 'fair' AND `I18n__fair__ita`.`locale` = 'ita') WHERE `active` = '0' | 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`, `Exhibition`.`regions`, `Exhibition`.`nation_id` FROM `forumagenti_website`.`exhibitions` AS `Exhibition` WHERE `Exhibition`.`fair_id` = (21) ORDER BY `Exhibition`.`startdate` DESC | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 31, exhibition ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 31, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 31, exhibitiontext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 31, exhibitiondescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 31, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 31, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 31, directions ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 31, 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` = (21) | 0 | 0 | 0 | |
SELECT content from fair_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Fair, ita, 21, fair ] | 1 | 1 | 0 | |
SELECT `Fair`.`suspended` FROM `forumagenti_website`.`fairs` AS `Fair` WHERE `Fair`.`id` = 31 AND `Fair`.`active` = '1' AND `Fair`.`suspended` = '1' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`pass`, `Route`.`controller`, `Route`.`action`, (`I18n__labelurl`.`content`) AS `Route__i18n_labelurl` FROM `forumagenti_website`.`routes` AS `Route` INNER JOIN `forumagenti_website`.`route_translations` AS `I18n__labelurl` ON (`Route`.`id` = `I18n__labelurl`.`foreign_key` AND `I18n__labelurl`.`model` = 'Route' AND `I18n__labelurl`.`field` = 'labelurl' AND `I18n__labelurl`.`locale` = 'ita') WHERE `Route`.`id` = 9641 LIMIT 1 | 1 | 1 | 0 | |
SELECT Route.id,Route.controller,Route.action,Route.url,Route.pass,Route.labelurl,
DynmenuRoutes.* FROM routes Route INNER JOIN dynamicmenus_routes DynmenuRoutes
ON Route.id = DynmenuRoutes.route_id WHERE DynmenuRoutes.parent_id = 9641 AND DynmenuRoutes.dynamicmenu_id= 292 ORDER BY DynmenuRoutes.order ASC | 0 | 0 | 0 | |
SELECT `Fair`.`suspended` FROM `forumagenti_website`.`fairs` AS `Fair` WHERE `Fair`.`id` = 41 AND `Fair`.`active` = '1' AND `Fair`.`suspended` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Fair`.`suspended` FROM `forumagenti_website`.`fairs` AS `Fair` WHERE `Fair`.`id` = 1 AND `Fair`.`active` = '1' AND `Fair`.`suspended` = '1' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Route`.`id`, `Route`.`pass`, `Route`.`controller`, `Route`.`action`, (`I18n__labelurl`.`content`) AS `Route__i18n_labelurl` FROM `forumagenti_website`.`routes` AS `Route` INNER JOIN `forumagenti_website`.`route_translations` AS `I18n__labelurl` ON (`Route`.`id` = `I18n__labelurl`.`foreign_key` AND `I18n__labelurl`.`model` = 'Route' AND `I18n__labelurl`.`field` = 'labelurl' AND `I18n__labelurl`.`locale` = 'ita') WHERE `Route`.`id` = 2431 LIMIT 1 | 1 | 1 | 0 | |
SELECT Route.id,Route.controller,Route.action,Route.url,Route.pass,Route.labelurl,
DynmenuRoutes.* FROM routes Route INNER JOIN dynamicmenus_routes DynmenuRoutes
ON Route.id = DynmenuRoutes.route_id WHERE DynmenuRoutes.parent_id = 2431 AND DynmenuRoutes.dynamicmenu_id= 292 ORDER BY DynmenuRoutes.order ASC | 0 | 0 | 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`.`randomnum` = 617 AND `Landing`.`landingurl` = 'simply-biz' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Generalconvention`.`id`, `Generalconvention`.`exhibition_id`, `Generalconvention`.`conventioncontent_id`, `Generalconvention`.`landing_id`, `Generalconvention`.`startdate`, `Generalconvention`.`enddate`, `Generalconvention`.`created`, `Generalconvention`.`modified` FROM `forumagenti_website`.`generalconventions` AS `Generalconvention` WHERE `Generalconvention`.`landing_id` = (39) | 1 | 1 | 0 | |
SELECT `Exhibition`.`id`, `Exhibition`.`exhibition`, `Exhibition`.`startdate`, `Exhibition`.`fair_id` FROM `forumagenti_website`.`exhibitions` AS `Exhibition` WHERE `Exhibition`.`id` = 311 ORDER BY `Exhibition`.`id` ASC | 1 | 1 | 0 | |
SELECT `Fair`.`fair`, `Fair`.`id` FROM `forumagenti_website`.`fairs` AS `Fair` WHERE `Fair`.`id` = 1 | 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 content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, ita, 311, exhibition ] | 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` FROM `forumagenti_website`.`conventioncontents` AS `Conventioncontent` WHERE `Conventioncontent`.`id` = 23 | 1 | 1 | 0 | |
SELECT content from conventioncontent_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Conventioncontent, ita, 23, convtitle ] | 1 | 1 | 0 | |
SELECT content from conventioncontent_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Conventioncontent, ita, 23, convcontent ] | 1 | 1 | 0 | |
SELECT content from conventioncontent_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Conventioncontent, ita, 23, reservationformtitle ] | 1 | 1 | 0 | |
SELECT content from conventioncontent_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Conventioncontent, ita, 23, reservationformcontent ] | 1 | 1 | 0 | |
SELECT content from landing_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Landing, ita, 39, name ] | 1 | 1 | 0 | |
SELECT content from landing_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Landing, ita, 39, title ] | 1 | 1 | 0 | |
SELECT content from landing_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Landing, ita, 39, content ] | 1 | 1 | 0 | |
SELECT content from landing_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Landing, ita, 39, bottomcontent ] | 1 | 1 | 0 | |
SELECT `Route`.`url` FROM `forumagenti_website`.`routes` AS `Route` WHERE `action` = 'home' AND `pass` = '1' LIMIT 1 | 1 | 1 | 0 | |