Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Product`.`id`, `Product`.`title`, `Product`.`title_seo`, `Product`.`alias`, `Product`.`category_id`, `Product`.`category_id2`, `Product`.`view`, `Product`.`content`, `Product`.`msp`, `Product`.`created`, `Product`.`status`, `Product`.`price`, `Product`.`hot`, `Product`.`meta_key`, `Product`.`meta_key_alias`, `Product`.`meta_des`, `Product`.`image1`, `Product`.`image2`, `Product`.`image3`, `Product`.`image4`, `Product`.`image5`, `Product`.`image6`, `Product`.`image1_thumb`, `Product`.`image2_thumb`, `Product`.`image3_thumb`, `Product`.`image4_thumb`, `Product`.`image5_thumb`, `Product`.`image6_thumb`, `Product`.`introduction`, `Product`.`modified`, `Product`.`order` FROM `dogophugia_data`.`products` AS `Product` WHERE `Product`.`status` = 1 AND `Product`.`meta_key_alias` like '%go huong da%' ORDER BY `Product`.`id` DESC LIMIT 20 | 20 | 20 | 5 | maybe slow |
SELECT COUNT(*) AS `count` FROM `dogophugia_data`.`products` AS `Product` WHERE `Product`.`status` = 1 AND `Product`.`meta_key_alias` like '%go huong da%' | 1 | 1 | 2 | maybe slow |
SELECT `Product`.`id`, `Product`.`title`, `Product`.`title_seo`, `Product`.`alias`, `Product`.`category_id`, `Product`.`category_id2`, `Product`.`view`, `Product`.`content`, `Product`.`msp`, `Product`.`created`, `Product`.`status`, `Product`.`price`, `Product`.`hot`, `Product`.`meta_key`, `Product`.`meta_key_alias`, `Product`.`meta_des`, `Product`.`image1`, `Product`.`image2`, `Product`.`image3`, `Product`.`image4`, `Product`.`image5`, `Product`.`image6`, `Product`.`image1_thumb`, `Product`.`image2_thumb`, `Product`.`image3_thumb`, `Product`.`image4_thumb`, `Product`.`image5_thumb`, `Product`.`image6_thumb`, `Product`.`introduction`, `Product`.`modified`, `Product`.`order` FROM `dogophugia_data`.`products` AS `Product` WHERE `Product`.`status` = 1 AND `Product`.`meta_key_alias` like '%go huong da%' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 1 AND `Category`.`parent_id` = 85 ORDER BY `Category`.`order` ASC | 6 | 6 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 94 ORDER BY `Category`.`order` ASC | 11 | 11 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 95 ORDER BY `Category`.`order` ASC | 6 | 6 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 96 ORDER BY `Category`.`order` ASC | 5 | 5 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 97 ORDER BY `Category`.`order` ASC | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 98 ORDER BY `Category`.`order` ASC | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 101 ORDER BY `Category`.`order` ASC | 5 | 5 | 0 | |
SELECT `Setting`.`id`, `Setting`.`footer`, `Setting`.`contac`, `Setting`.`email`, `Setting`.`facebook`, `Setting`.`title`, `Setting`.`meta_key`, `Setting`.`meta_des`, `Setting`.`logo`, `Setting`.`maps`, `Setting`.`slogan`, `Setting`.`hethong`, `Setting`.`hotline`, `Setting`.`pass`, `Setting`.`youtube` FROM `dogophugia_data`.`settings` AS `Setting` WHERE `Setting`.`id` = 99 LIMIT 1 | 1 | 1 | 0 | |
SELECT `News`.`id`, `News`.`user_id`, `News`.`title`, `News`.`alias`, `News`.`content`, `News`.`introduction`, `News`.`category_id`, `News`.`category_id1`, `News`.`view`, `News`.`created`, `News`.`status`, `News`.`modified`, `News`.`tag`, `News`.`meta_des`, `News`.`image`, `News`.`image_thumb`, `News`.`order`, `News`.`hot` FROM `dogophugia_data`.`news` AS `News` WHERE `News`.`status` = 1 AND `News`.`hot` = 1 ORDER BY `News`.`order` DESC | 10 | 10 | 0 | |
SELECT `News`.`id`, `News`.`user_id`, `News`.`title`, `News`.`alias`, `News`.`content`, `News`.`introduction`, `News`.`category_id`, `News`.`category_id1`, `News`.`view`, `News`.`created`, `News`.`status`, `News`.`modified`, `News`.`tag`, `News`.`meta_des`, `News`.`image`, `News`.`image_thumb`, `News`.`order`, `News`.`hot` FROM `dogophugia_data`.`news` AS `News` WHERE `News`.`status` = 1 ORDER BY `News`.`id` DESC LIMIT 10 | 10 | 10 | 0 | |
SELECT `Slide`.`id`, `Slide`.`name`, `Slide`.`images`, `Slide`.`link`, `Slide`.`modified`, `Slide`.`created`, `Slide`.`order`, `Slide`.`status`, `Slide`.`phanloai` FROM `dogophugia_data`.`slides` AS `Slide` WHERE `Slide`.`status` = 1 ORDER BY `Slide`.`order` ASC | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`footer`, `Setting`.`contac`, `Setting`.`email`, `Setting`.`facebook`, `Setting`.`title`, `Setting`.`meta_key`, `Setting`.`meta_des`, `Setting`.`logo`, `Setting`.`maps`, `Setting`.`slogan`, `Setting`.`hethong`, `Setting`.`hotline`, `Setting`.`pass`, `Setting`.`youtube` FROM `dogophugia_data`.`settings` AS `Setting` WHERE `Setting`.`id` = 99 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`footer`, `Setting`.`contac`, `Setting`.`email`, `Setting`.`facebook`, `Setting`.`title`, `Setting`.`meta_key`, `Setting`.`meta_des`, `Setting`.`logo`, `Setting`.`maps`, `Setting`.`slogan`, `Setting`.`hethong`, `Setting`.`hotline`, `Setting`.`pass`, `Setting`.`youtube` FROM `dogophugia_data`.`settings` AS `Setting` WHERE `Setting`.`id` = 99 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`meta_key` FROM `dogophugia_data`.`products` AS `Product` WHERE `status` = 1 AND NOT (`meta_key` IS NULL) ORDER BY `id` DESC | 897 | 897 | 0 | |
2 duplicate queries run.