Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Route`.`controller`, `Route`.`action`, `Route`.`pass` FROM `forumagenti_website`.`routes` AS `Route` WHERE `Route`.`url` = '454/special/cna-ferrara/contatti' 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` = 'spa') 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` = 'spa') WHERE `Landing`.`randomnum` = 454 AND `Landing`.`landingurl` = 'cna-ferrara' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Dynamicmenu`.`id` FROM `forumagenti_website`.`dynamicmenus` AS `Dynamicmenu` WHERE `dynamicmenu` = 'landing-menu' LIMIT 1 | 1 | 1 | 1 | |
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 | 1 | maybe slow |
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__spa`.`content`) AS `Fair__i18n_fair_spa` FROM `forumagenti_website`.`fairs` AS `Fair` LEFT JOIN `forumagenti_website`.`fair_translations` AS `I18n__fair__spa` ON (`Fair`.`id` = `I18n__fair__spa`.`foreign_key` AND `I18n__fair__spa`.`model` = 'Fair' AND `I18n__fair__spa`.`field` = 'fair' AND `I18n__fair__spa`.`locale` = 'spa') 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, spa, 31, exhibition ] | 0 | 0 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, eng, 31, exhibition ] | 0 | 0 | 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, spa, 31, datetimedetail ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, spa, 31, exhibitiontext ] | 0 | 0 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, eng, 31, exhibitiontext ] | 0 | 0 | 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, spa, 31, exhibitiondescr ] | 0 | 0 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, eng, 31, exhibitiondescr ] | 0 | 0 | 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, spa, 31, exhibitionendtext ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, spa, 31, exhibitionenddescr ] | 1 | 1 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, spa, 31, directions ] | 0 | 0 | 0 | |
SELECT content from exhibition_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Exhibition, eng, 31, directions ] | 0 | 0 | 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, spa, 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, spa, 21, fair ] | 0 | 0 | 0 | |
SELECT content from fair_translations WHERE model = ? AND locale = ? AND foreign_key = ? AND field = ? LIMIT 1 [ Fair, eng, 21, fair ] | 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` = 'spa') 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` = 'spa') 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 | |