Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `BlogPost`.`id`, `BlogPost`.`slug`, `BlogPost`.`user_id`, `BlogPost`.`blog_id`, `BlogPost`.`autor_name`, `BlogPost`.`title`, `BlogPost`.`body`, `BlogPost`.`images`, `BlogPost`.`short_description`, `BlogPost`.`keywords`, `BlogPost`.`intro_image`, `BlogPost`.`intro_image_mobile`, `BlogPost`.`active`, `BlogPost`.`deleted`, `BlogPost`.`archived`, `BlogPost`.`tags`, `BlogPost`.`promo_url`, `BlogPost`.`alternative_url`, `BlogPost`.`theme`, `BlogPost`.`layout`, `BlogPost`.`view`, `BlogPost`.`style`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`lng`, `BlogPost`.`canonical`, `BlogPost`.`logo`, `BlogPost`.`index`, `BlogPost`.`blog_author_id`, `BlogPost`.`h1` FROM `sleeveuphomes`.`blog_post` AS `BlogPost` WHERE `active` = '1' AND `blog_id` IN (5, 6, 7, 8, 9) ORDER BY `created` desc LIMIT 5 | 5 | 5 | 2 | maybe slow |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'META_TITLE' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Settings`.`id`, `Settings`.`default`, `Settings`.`name`, `Settings`.`value`, `Settings`.`created`, `Settings`.`modified` FROM `sleeveuphomes`.`settings` AS `Settings` WHERE `Settings`.`name` = 'site_conf' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'META_DESCRIPTION' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'META_KEYWORDS' LIMIT 1 | 1 | 1 | 0 | |
SELECT `StateProvince`.`id`, `StateProvince`.`name` FROM `sleeveuphomes`.`state_province` AS `StateProvince` WHERE `StateProvince`.`country_id` = (1) | 59 | 59 | 1 | |
SELECT `Country`.`id`, `Country`.`country` FROM `sleeveuphomes`.`country` AS `Country` WHERE `Country`.`id` = (1) ORDER BY `Country`.`id` asc | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name` FROM `sleeveuphomes`.`categories` AS `Category` WHERE `Category`.`type` = 'product' AND `Category`.`parent_id` IS NULL AND `Category`.`active` = '1' ORDER BY `Category`.`lft` asc | 1 | 1 | 0 | |
SELECT `Menu`.`id`, `Menu`.`alias` FROM `sleeveuphomes`.`menu` AS `Menu` WHERE 1 = 1 | 2 | 2 | 0 | |
SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`alias`, `Menu`.`description`, `Menu`.`lft`, `Menu`.`rght` FROM `sleeveuphomes`.`menu` AS `Menu` WHERE `alias` = 'header_menu_front' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MenuItem`.`target`, `MenuItem`.`rel`, `MenuItem`.`id`, `MenuItem`.`path`, `MenuItem`.`title`, `MenuItem`.`description`, `MenuItem`.`menu_id`, `MenuItem`.`parent_id`, `MenuItem`.`lft`, `MenuItem`.`rght`, `MenuItem`.`class` FROM `sleeveuphomes`.`menu_item` AS `MenuItem` WHERE `menu_id` = 1 ORDER BY `MenuItem`.`lft` ASC | 7 | 7 | 1 | maybe slow |
SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`alias`, `Menu`.`description`, `Menu`.`lft`, `Menu`.`rght` FROM `sleeveuphomes`.`menu` AS `Menu` WHERE `alias` = 'header_menu' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MenuItem`.`target`, `MenuItem`.`rel`, `MenuItem`.`id`, `MenuItem`.`path`, `MenuItem`.`title`, `MenuItem`.`description`, `MenuItem`.`menu_id`, `MenuItem`.`parent_id`, `MenuItem`.`lft`, `MenuItem`.`rght`, `MenuItem`.`class` FROM `sleeveuphomes`.`menu_item` AS `MenuItem` WHERE `menu_id` = 2 ORDER BY `MenuItem`.`lft` ASC | 3 | 3 | 0 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'META_DESCRIPTION_BLOG' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'META_KEYWORDS_BLOG' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'META_IMAGE_BLOG' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Blog`.`id`, `Blog`.`title`, `Blog`.`data`, `Blog`.`description`, `Blog`.`active`, `Blog`.`deleted`, `Blog`.`home`, `Blog`.`created`, `Blog`.`modified`, `Blog`.`lng` FROM `sleeveuphomes`.`blog` AS `Blog` WHERE `Blog`.`data` = 'resource-library' LIMIT 1 | 1 | 1 | 0 | |
SELECT `BlogPost`.`id`, `BlogPost`.`slug`, `BlogPost`.`user_id`, `BlogPost`.`blog_id`, `BlogPost`.`autor_name`, `BlogPost`.`title`, `BlogPost`.`body`, `BlogPost`.`images`, `BlogPost`.`short_description`, `BlogPost`.`keywords`, `BlogPost`.`intro_image`, `BlogPost`.`intro_image_mobile`, `BlogPost`.`active`, `BlogPost`.`deleted`, `BlogPost`.`archived`, `BlogPost`.`tags`, `BlogPost`.`promo_url`, `BlogPost`.`alternative_url`, `BlogPost`.`theme`, `BlogPost`.`layout`, `BlogPost`.`view`, `BlogPost`.`style`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`lng`, `BlogPost`.`canonical`, `BlogPost`.`logo`, `BlogPost`.`index`, `BlogPost`.`blog_author_id`, `BlogPost`.`h1` FROM `sleeveuphomes`.`blog_post` AS `BlogPost` WHERE `BlogPost`.`blog_id` = (9) | 35 | 35 | 2 | maybe slow |
SELECT `BlogPost`.`id`, `BlogPost`.`slug`, `BlogPost`.`user_id`, `BlogPost`.`blog_id`, `BlogPost`.`autor_name`, `BlogPost`.`title`, `BlogPost`.`body`, `BlogPost`.`images`, `BlogPost`.`short_description`, `BlogPost`.`keywords`, `BlogPost`.`intro_image`, `BlogPost`.`intro_image_mobile`, `BlogPost`.`active`, `BlogPost`.`deleted`, `BlogPost`.`archived`, `BlogPost`.`tags`, `BlogPost`.`promo_url`, `BlogPost`.`alternative_url`, `BlogPost`.`theme`, `BlogPost`.`layout`, `BlogPost`.`view`, `BlogPost`.`style`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`lng`, `BlogPost`.`canonical`, `BlogPost`.`logo`, `BlogPost`.`index`, `BlogPost`.`blog_author_id`, `BlogPost`.`h1`, `User`.`id`, `User`.`email`, `User`.`name`, `User`.`password`, `User`.`public_id`, `User`.`active`, `User`.`tokenhash`, `User`.`avatar`, `User`.`last_login`, `User`.`created`, `User`.`modified`, `Blog`.`id`, `Blog`.`title`, `Blog`.`data`, `Blog`.`description`, `Blog`.`active`, `Blog`.`deleted`, `Blog`.`home`, `Blog`.`created`, `Blog`.`modified`, `Blog`.`lng`, `BlogPostAuthor`.`id`, `BlogPostAuthor`.`name`, `BlogPostAuthor`.`description`, `BlogPostAuthor`.`image`, `BlogPostAuthor`.`title`, `BlogPostAuthor`.`linkedin_link`, `BlogPostAuthor`.`created`, `BlogPostAuthor`.`modefied` FROM `sleeveuphomes`.`blog_post` AS `BlogPost` LEFT JOIN `sleeveuphomes`.`users` AS `User` ON (`BlogPost`.`user_id` = `User`.`id`) LEFT JOIN `sleeveuphomes`.`blog` AS `Blog` ON (`BlogPost`.`blog_id` = `Blog`.`id`) LEFT JOIN `sleeveuphomes`.`blog_authors` AS `BlogPostAuthor` ON (`BlogPost`.`blog_author_id` = `BlogPostAuthor`.`id`) WHERE ((`BlogPost`.`active` = '1') AND (`BlogPost`.`lng` = 'eng')) AND `BlogPost`.`blog_id` = 9 ORDER BY `BlogPost`.`created` desc LIMIT 20 | 20 | 20 | 3 | maybe slow |
SELECT COUNT(*) AS `count` FROM `sleeveuphomes`.`blog_post` AS `BlogPost` LEFT JOIN `sleeveuphomes`.`users` AS `User` ON (`BlogPost`.`user_id` = `User`.`id`) LEFT JOIN `sleeveuphomes`.`blog` AS `Blog` ON (`BlogPost`.`blog_id` = `Blog`.`id`) LEFT JOIN `sleeveuphomes`.`blog_authors` AS `BlogPostAuthor` ON (`BlogPost`.`blog_author_id` = `BlogPostAuthor`.`id`) WHERE ((`BlogPost`.`active` = '1') AND (`BlogPost`.`lng` = 'eng')) AND `BlogPost`.`blog_id` = 9 | 1 | 1 | 1 | |
SELECT `Blog`.`id`, `Blog`.`title`, `Blog`.`data`, `Blog`.`description`, `Blog`.`active`, `Blog`.`deleted`, `Blog`.`home`, `Blog`.`created`, `Blog`.`modified`, `Blog`.`lng` FROM `sleeveuphomes`.`blog` AS `Blog` WHERE `Blog`.`active` = '1' | 6 | 6 | 0 | |
SELECT `BlogPost`.`id`, `BlogPost`.`slug`, `BlogPost`.`user_id`, `BlogPost`.`blog_id`, `BlogPost`.`autor_name`, `BlogPost`.`title`, `BlogPost`.`body`, `BlogPost`.`images`, `BlogPost`.`short_description`, `BlogPost`.`keywords`, `BlogPost`.`intro_image`, `BlogPost`.`intro_image_mobile`, `BlogPost`.`active`, `BlogPost`.`deleted`, `BlogPost`.`archived`, `BlogPost`.`tags`, `BlogPost`.`promo_url`, `BlogPost`.`alternative_url`, `BlogPost`.`theme`, `BlogPost`.`layout`, `BlogPost`.`view`, `BlogPost`.`style`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`lng`, `BlogPost`.`canonical`, `BlogPost`.`logo`, `BlogPost`.`index`, `BlogPost`.`blog_author_id`, `BlogPost`.`h1` FROM `sleeveuphomes`.`blog_post` AS `BlogPost` WHERE `BlogPost`.`blog_id` IN (1, 5, 6, 7, 8, 9) | 139 | 139 | 5 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'site_conf' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'site_conf' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'site_conf' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'site_conf' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'HEADER' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`default`, `Setting`.`name`, `Setting`.`value`, `Setting`.`created`, `Setting`.`modified` FROM `sleeveuphomes`.`settings` AS `Setting` WHERE `Setting`.`name` = 'FOOTER' LIMIT 1 | 1 | 1 | 0 | |
3 duplicate queries run.