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 `Property`.`id`, `Property`.`catproperty_id`, `Property`.`title`, `Property`.`slug`, `Property`.`image`, `Property`.`des`, `Property`.`content`, `Property`.`public`, `Property`.`hot`, `Property`.`vip`, `Property`.`order_num`, `Property`.`titleseo`, `Property`.`description`, `Property`.`keywords`, `Property`.`created`, `Property`.`modified`, `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`.`properties` AS `Property` LEFT JOIN `nguyenmanh_db`.`catproperties` AS `Catproperty` ON (`Property`.`catproperty_id` = `Catproperty`.`id`) WHERE `Property`.`slug` = 'diem-danh-du-an-bds-noi-bat-cua-tan-hoang-minh' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Property`.`id`, `Property`.`title`, `Property`.`slug`, `Property`.`image`, `Property`.`public` FROM `nguyenmanh_db`.`properties` AS `Property` LEFT JOIN `nguyenmanh_db`.`catproperties` AS `Catproperty` ON (`Property`.`catproperty_id` = `Catproperty`.`id`) WHERE `catproperty_id` = 10 AND `Property`.`id` <> 23 AND `Property`.`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 | 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 `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 | 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 `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 | 0 | |
13 duplicate queries run.