Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `Setting`.`info`, `Setting`.`thanks`, `Setting`.`skype`, `Setting`.`tel_number`, `Setting`.`titleseo`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`address`, `Setting`.`maps`, `Setting`.`fb_link`, `Setting`.`tw_link`, `Setting`.`yt_link`, `Setting`.`gg_link`, `Setting`.`show_fb_chat`, `Setting`.`show_call_button`, `Setting`.`show_go_top`, `Setting`.`info_contact`, `Setting`.`image_avatar` FROM `nguyenmanh_db`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`name`, `Slideshow`.`image`, `Slideshow`.`link`, `Slideshow`.`des`, `Slideshow`.`position`, `Slideshow`.`public`, `Slideshow`.`created`, `Slideshow`.`modified` FROM `nguyenmanh_db`.`slideshows` AS `Slideshow` WHERE `Slideshow`.`public` = '1' | 2 | 2 | 0 | |
SELECT `Train`.`id`, `Train`.`cattrain_id`, `Train`.`title`, `Train`.`slug`, `Train`.`image`, `Train`.`des`, `Train`.`content`, `Train`.`public`, `Train`.`hot`, `Train`.`vip`, `Train`.`order`, `Train`.`titleseo`, `Train`.`description`, `Train`.`keywords`, `Train`.`created`, `Train`.`modified`, `Cattrain`.`id`, `Cattrain`.`parent_id`, `Cattrain`.`lft`, `Cattrain`.`rght`, `Cattrain`.`name`, `Cattrain`.`slug`, `Cattrain`.`folder`, `Cattrain`.`image`, `Cattrain`.`public`, `Cattrain`.`pos`, `Cattrain`.`des`, `Cattrain`.`content`, `Cattrain`.`titleseo`, `Cattrain`.`description`, `Cattrain`.`keywords`, `Cattrain`.`created`, `Cattrain`.`modified` FROM `nguyenmanh_db`.`trains` AS `Train` LEFT JOIN `nguyenmanh_db`.`cattrains` AS `Cattrain` ON (`Train`.`cattrain_id` = `Cattrain`.`id`) WHERE `Train`.`slug` = 'nghe-thuat-chot-sale-bat-dong-san' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Train`.`id`, `Train`.`title`, `Train`.`slug`, `Train`.`image`, `Train`.`public` FROM `nguyenmanh_db`.`trains` AS `Train` LEFT JOIN `nguyenmanh_db`.`cattrains` AS `Cattrain` ON (`Train`.`cattrain_id` = `Cattrain`.`id`) WHERE `cattrain_id` = 5 AND `Train`.`id` <> 14 AND `Train`.`public` = '1' ORDER BY rand() ASC LIMIT 5 | 5 | 5 | 1 | maybe slow |
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `Setting`.`info`, `Setting`.`thanks`, `Setting`.`skype`, `Setting`.`tel_number`, `Setting`.`titleseo`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`address`, `Setting`.`maps`, `Setting`.`fb_link`, `Setting`.`tw_link`, `Setting`.`yt_link`, `Setting`.`gg_link`, `Setting`.`show_fb_chat`, `Setting`.`show_call_button`, `Setting`.`show_go_top`, `Setting`.`info_contact`, `Setting`.`image_avatar` FROM `nguyenmanh_db`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`name`, `Slideshow`.`image`, `Slideshow`.`link`, `Slideshow`.`des`, `Slideshow`.`position`, `Slideshow`.`public`, `Slideshow`.`created`, `Slideshow`.`modified` FROM `nguyenmanh_db`.`slideshows` AS `Slideshow` WHERE `Slideshow`.`public` = '1' | 2 | 2 | 0 | |
SELECT `Insertcode`.`id`, `Insertcode`.`title`, `Insertcode`.`content`, `Insertcode`.`public`, `Insertcode`.`pos_top`, `Insertcode`.`pos_footer`, `Insertcode`.`created`, `Insertcode`.`modified` FROM `nguyenmanh_db`.`insertcodes` AS `Insertcode` WHERE `Insertcode`.`pos_top` = '1' AND `Insertcode`.`public` = '1' | 0 | 0 | 0 | |
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `Setting`.`info`, `Setting`.`thanks`, `Setting`.`skype`, `Setting`.`tel_number`, `Setting`.`titleseo`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`address`, `Setting`.`maps`, `Setting`.`fb_link`, `Setting`.`tw_link`, `Setting`.`yt_link`, `Setting`.`gg_link`, `Setting`.`show_fb_chat`, `Setting`.`show_call_button`, `Setting`.`show_go_top`, `Setting`.`info_contact`, `Setting`.`image_avatar` FROM `nguyenmanh_db`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`name`, `Slideshow`.`image`, `Slideshow`.`link`, `Slideshow`.`des`, `Slideshow`.`position`, `Slideshow`.`public`, `Slideshow`.`created`, `Slideshow`.`modified` FROM `nguyenmanh_db`.`slideshows` AS `Slideshow` WHERE `Slideshow`.`public` = '1' | 2 | 2 | 0 | |
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `Setting`.`info`, `Setting`.`thanks`, `Setting`.`skype`, `Setting`.`tel_number`, `Setting`.`titleseo`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`address`, `Setting`.`maps`, `Setting`.`fb_link`, `Setting`.`tw_link`, `Setting`.`yt_link`, `Setting`.`gg_link`, `Setting`.`show_fb_chat`, `Setting`.`show_call_button`, `Setting`.`show_go_top`, `Setting`.`info_contact`, `Setting`.`image_avatar` FROM `nguyenmanh_db`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `Setting`.`info`, `Setting`.`thanks`, `Setting`.`skype`, `Setting`.`tel_number`, `Setting`.`titleseo`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`address`, `Setting`.`maps`, `Setting`.`fb_link`, `Setting`.`tw_link`, `Setting`.`yt_link`, `Setting`.`gg_link`, `Setting`.`show_fb_chat`, `Setting`.`show_call_button`, `Setting`.`show_go_top`, `Setting`.`info_contact`, `Setting`.`image_avatar` FROM `nguyenmanh_db`.`settings` AS `Setting` WHERE 1 = 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `Setting`.`info`, `Setting`.`thanks`, `Setting`.`skype`, `Setting`.`tel_number`, `Setting`.`titleseo`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`address`, `Setting`.`maps`, `Setting`.`fb_link`, `Setting`.`tw_link`, `Setting`.`yt_link`, `Setting`.`gg_link`, `Setting`.`show_fb_chat`, `Setting`.`show_call_button`, `Setting`.`show_go_top`, `Setting`.`info_contact`, `Setting`.`image_avatar` FROM `nguyenmanh_db`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`name`, `Slideshow`.`image`, `Slideshow`.`link`, `Slideshow`.`des`, `Slideshow`.`position`, `Slideshow`.`public`, `Slideshow`.`created`, `Slideshow`.`modified` FROM `nguyenmanh_db`.`slideshows` AS `Slideshow` WHERE `Slideshow`.`public` = '1' | 2 | 2 | 0 | |
SELECT `Catshare`.`id`, `Catshare`.`parent_id`, `Catshare`.`lft`, `Catshare`.`rght`, `Catshare`.`name`, `Catshare`.`slug`, `Catshare`.`folder`, `Catshare`.`image`, `Catshare`.`public`, `Catshare`.`pos`, `Catshare`.`des`, `Catshare`.`content`, `Catshare`.`titleseo`, `Catshare`.`description`, `Catshare`.`keywords`, `Catshare`.`created`, `Catshare`.`modified` FROM `nguyenmanh_db`.`catshares` AS `Catshare` WHERE `Catshare`.`public` = '1' ORDER BY `Catshare`.`pos` asc | 2 | 2 | 1 | maybe slow |
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `Setting`.`info`, `Setting`.`thanks`, `Setting`.`skype`, `Setting`.`tel_number`, `Setting`.`titleseo`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`address`, `Setting`.`maps`, `Setting`.`fb_link`, `Setting`.`tw_link`, `Setting`.`yt_link`, `Setting`.`gg_link`, `Setting`.`show_fb_chat`, `Setting`.`show_call_button`, `Setting`.`show_go_top`, `Setting`.`info_contact`, `Setting`.`image_avatar` FROM `nguyenmanh_db`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`name`, `Slideshow`.`image`, `Slideshow`.`link`, `Slideshow`.`des`, `Slideshow`.`position`, `Slideshow`.`public`, `Slideshow`.`created`, `Slideshow`.`modified` FROM `nguyenmanh_db`.`slideshows` AS `Slideshow` WHERE `Slideshow`.`public` = '1' | 2 | 2 | 0 | |
SELECT `Catproperty`.`id`, `Catproperty`.`parent_id`, `Catproperty`.`lft`, `Catproperty`.`rght`, `Catproperty`.`name`, `Catproperty`.`slug`, `Catproperty`.`folder`, `Catproperty`.`image`, `Catproperty`.`public`, `Catproperty`.`pos`, `Catproperty`.`des`, `Catproperty`.`content`, `Catproperty`.`titleseo`, `Catproperty`.`description`, `Catproperty`.`keywords`, `Catproperty`.`created`, `Catproperty`.`modified` FROM `nguyenmanh_db`.`catproperties` AS `Catproperty` WHERE `Catproperty`.`public` = '1' ORDER BY `Catproperty`.`pos` asc | 4 | 4 | 1 | maybe slow |
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `Setting`.`info`, `Setting`.`thanks`, `Setting`.`skype`, `Setting`.`tel_number`, `Setting`.`titleseo`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`address`, `Setting`.`maps`, `Setting`.`fb_link`, `Setting`.`tw_link`, `Setting`.`yt_link`, `Setting`.`gg_link`, `Setting`.`show_fb_chat`, `Setting`.`show_call_button`, `Setting`.`show_go_top`, `Setting`.`info_contact`, `Setting`.`image_avatar` FROM `nguyenmanh_db`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`name`, `Slideshow`.`image`, `Slideshow`.`link`, `Slideshow`.`des`, `Slideshow`.`position`, `Slideshow`.`public`, `Slideshow`.`created`, `Slideshow`.`modified` FROM `nguyenmanh_db`.`slideshows` AS `Slideshow` WHERE `Slideshow`.`public` = '1' | 2 | 2 | 0 | |
SELECT `Cattrain`.`id`, `Cattrain`.`parent_id`, `Cattrain`.`lft`, `Cattrain`.`rght`, `Cattrain`.`name`, `Cattrain`.`slug`, `Cattrain`.`folder`, `Cattrain`.`image`, `Cattrain`.`public`, `Cattrain`.`pos`, `Cattrain`.`des`, `Cattrain`.`content`, `Cattrain`.`titleseo`, `Cattrain`.`description`, `Cattrain`.`keywords`, `Cattrain`.`created`, `Cattrain`.`modified` FROM `nguyenmanh_db`.`cattrains` AS `Cattrain` WHERE `Cattrain`.`public` = '1' ORDER BY `Cattrain`.`pos` asc | 2 | 2 | 0 | |
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `Setting`.`info`, `Setting`.`thanks`, `Setting`.`skype`, `Setting`.`tel_number`, `Setting`.`titleseo`, `Setting`.`description`, `Setting`.`keywords`, `Setting`.`address`, `Setting`.`maps`, `Setting`.`fb_link`, `Setting`.`tw_link`, `Setting`.`yt_link`, `Setting`.`gg_link`, `Setting`.`show_fb_chat`, `Setting`.`show_call_button`, `Setting`.`show_go_top`, `Setting`.`info_contact`, `Setting`.`image_avatar` FROM `nguyenmanh_db`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Slideshow`.`id`, `Slideshow`.`name`, `Slideshow`.`image`, `Slideshow`.`link`, `Slideshow`.`des`, `Slideshow`.`position`, `Slideshow`.`public`, `Slideshow`.`created`, `Slideshow`.`modified` FROM `nguyenmanh_db`.`slideshows` AS `Slideshow` WHERE `Slideshow`.`public` = '1' | 2 | 2 | 0 | |
SELECT `Catpost`.`id`, `Catpost`.`parent_id`, `Catpost`.`lft`, `Catpost`.`rght`, `Catpost`.`name`, `Catpost`.`slug`, `Catpost`.`folder`, `Catpost`.`image`, `Catpost`.`public`, `Catpost`.`pos`, `Catpost`.`des`, `Catpost`.`content`, `Catpost`.`titleseo`, `Catpost`.`description`, `Catpost`.`keywords`, `Catpost`.`created`, `Catpost`.`modified` FROM `nguyenmanh_db`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' ORDER BY `Catpost`.`pos` asc | 2 | 2 | 1 | maybe slow |
13 duplicate queries run.