(default) 11 queries took 38 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `BlogPost`.`id`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`media_id`, `BlogPost`.`enligne`, `BlogPost`.`sticky`, `BlogPost`.`in_rss`, `BlogPost`.`meta_title`, `BlogPost`.`meta_description`, `BlogPost`.`meta_keywords`, `BlogPost`.`created`, `BlogPost`.`modified`, (`I18n___title`.`content`) AS `BlogPost__i18n__title`, (`I18n___slug`.`content`) AS `BlogPost__i18n__slug`, (`I18n___summary`.`content`) AS `BlogPost__i18n__summary`, (`I18n___body`.`content`) AS `BlogPost__i18n__body`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position` FROM `cobratours`.`blog_posts` AS `BlogPost` inner JOIN `cobratours`.`tags_blog_posts` AS `TagsBlogPost` ON (`TagsBlogPost`.`blog_post_id`=`BlogPost`.`id` AND `TagsBlogPost`.`blog_post_tag` = 'biblios') INNER JOIN `cobratours`.`i18n` AS `I18n___title` ON (`BlogPost`.`id` = `I18n___title`.`foreign_key` AND `I18n___title`.`model` = 'BlogPost' AND `I18n___title`.`field` = 'title' AND `I18n___title`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___slug` ON (`BlogPost`.`id` = `I18n___slug`.`foreign_key` AND `I18n___slug`.`model` = 'BlogPost' AND `I18n___slug`.`field` = 'slug' AND `I18n___slug`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___summary` ON (`BlogPost`.`id` = `I18n___summary`.`foreign_key` AND `I18n___summary`.`model` = 'BlogPost' AND `I18n___summary`.`field` = 'summary' AND `I18n___summary`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___body` ON (`BlogPost`.`id` = `I18n___body`.`foreign_key` AND `I18n___body`.`model` = 'BlogPost' AND `I18n___body`.`field` = 'body' AND `I18n___body`.`locale` = 'ita') LEFT JOIN `cobratours`.`medias` AS `Thumb` ON (`BlogPost`.`media_id` = `Thumb`.`id`) WHERE `BlogPost`.`enligne` = 1 ORDER BY `BlogPost`.`id` desc001
2SELECT `BlogPostCategory`.`id`, `BlogPostCategory`.`name`, `BlogPostCategory`.`slug` FROM `cobratours`.`blog_post_categories` AS `BlogPostCategory` WHERE 1 = 1116
3SELECT `TagsBlogPost`.`blog_post_tag`, `TagsBlogPost`.`blog_post_id` FROM `cobratours`.`tags_blog_posts` AS `TagsBlogPost` WHERE 1 = 1000
4SELECT `BlogPost`.`id`, `BlogPost`.`title`, `BlogPost`.`slug`, `BlogPost`.`summary`, `BlogPost`.`body`, `BlogPost`.`media_id`, `BlogPost`.`enligne`, `BlogPost`.`sticky`, `BlogPost`.`in_rss`, `BlogPost`.`meta_title`, `BlogPost`.`meta_description`, `BlogPost`.`meta_keywords`, `BlogPost`.`created`, `BlogPost`.`modified`, (`I18n___title`.`content`) AS `BlogPost__i18n__title`, (`I18n___slug`.`content`) AS `BlogPost__i18n__slug`, (`I18n___summary`.`content`) AS `BlogPost__i18n__summary`, (`I18n___body`.`content`) AS `BlogPost__i18n__body`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position` FROM `cobratours`.`blog_posts` AS `BlogPost` INNER JOIN `cobratours`.`i18n` AS `I18n___title` ON (`BlogPost`.`id` = `I18n___title`.`foreign_key` AND `I18n___title`.`model` = 'BlogPost' AND `I18n___title`.`field` = 'title' AND `I18n___title`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___slug` ON (`BlogPost`.`id` = `I18n___slug`.`foreign_key` AND `I18n___slug`.`model` = 'BlogPost' AND `I18n___slug`.`field` = 'slug' AND `I18n___slug`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___summary` ON (`BlogPost`.`id` = `I18n___summary`.`foreign_key` AND `I18n___summary`.`model` = 'BlogPost' AND `I18n___summary`.`field` = 'summary' AND `I18n___summary`.`locale` = 'ita') INNER JOIN `cobratours`.`i18n` AS `I18n___body` ON (`BlogPost`.`id` = `I18n___body`.`foreign_key` AND `I18n___body`.`model` = 'BlogPost' AND `I18n___body`.`field` = 'body' AND `I18n___body`.`locale` = 'ita') LEFT JOIN `cobratours`.`medias` AS `Thumb` ON (`BlogPost`.`media_id` = `Thumb`.`id`) WHERE `BlogPost`.`enligne` = 1 ORDER BY `BlogPost`.`id` desc LIMIT 55519
5SELECT `TagsBlogPost`.`blog_post_tag`, `TagsBlogPost`.`blog_post_id` FROM `cobratours`.`tags_blog_posts` AS `TagsBlogPost` WHERE `TagsBlogPost`.`blog_post_id` IN (33, 32, 31, 28, 27) 002
6SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `cobratours`.`medias` AS `Media` WHERE ref = "BlogPost" AND `Media`.`ref_id` IN (33, 32, 31, 28, 27) ORDER BY `Media`.`position` ASC 991
7SELECT `_title`.`id`, `_title`.`locale`, `_title`.`model`, `_title`.`foreign_key`, `_title`.`field`, `_title`.`content` FROM `cobratours`.`i18n` AS `_title` WHERE `model` = 'BlogPost' AND `field` = 'title' AND `_title`.`foreign_key` IN (33, 32, 31, 28, 27) 10101
8SELECT `_slug`.`id`, `_slug`.`locale`, `_slug`.`model`, `_slug`.`foreign_key`, `_slug`.`field`, `_slug`.`content` FROM `cobratours`.`i18n` AS `_slug` WHERE `model` = 'BlogPost' AND `field` = 'slug' AND `_slug`.`foreign_key` IN (33, 32, 31, 28, 27) 10101
9SELECT `_summary`.`id`, `_summary`.`locale`, `_summary`.`model`, `_summary`.`foreign_key`, `_summary`.`field`, `_summary`.`content` FROM `cobratours`.`i18n` AS `_summary` WHERE `model` = 'BlogPost' AND `field` = 'summary' AND `_summary`.`foreign_key` IN (33, 32, 31, 28, 27) 10101
10SELECT `_body`.`id`, `_body`.`locale`, `_body`.`model`, `_body`.`foreign_key`, `_body`.`field`, `_body`.`content` FROM `cobratours`.`i18n` AS `_body` WHERE `model` = 'BlogPost' AND `field` = 'body' AND `_body`.`foreign_key` IN (33, 32, 31, 28, 27) 10102
11SELECT `BlogPostCategory`.`id`, `BlogPostCategory`.`parent_id`, `BlogPostCategory`.`lft`, `BlogPostCategory`.`rght`, `BlogPostCategory`.`name`, `BlogPostCategory`.`slug`, `BlogPostCategory`.`meta_title`, `BlogPostCategory`.`meta_description`, `BlogPostCategory`.`meta_keywords`, `BlogPostCategory`.`rss_channel_title`, `BlogPostCategory`.`rss_channel_description`, `BlogPostCategory`.`blog_post_count`, `BlogPostCategory`.`under_blog_post_count`, `BlogPostCategory`.`created`, `BlogPostCategory`.`modified`, `BlogPostCategoriesBlogPost`.`blog_post_category_id`, `BlogPostCategoriesBlogPost`.`blog_post_id` FROM `cobratours`.`blog_post_categories` AS `BlogPostCategory` JOIN `cobratours`.`blog_post_categories_blog_posts` AS `BlogPostCategoriesBlogPost` ON (`BlogPostCategoriesBlogPost`.`blog_post_id` IN (33, 32, 31, 28, 27) AND `BlogPostCategoriesBlogPost`.`blog_post_category_id` = `BlogPostCategory`.`id`) 004