Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT COUNT(*) AS `count` FROM `admin_tlqn2021`.`counters` AS `Counter` WHERE 1 = 1 | 1 | 1 | 7 | maybe slow |
SELECT `Setting`.* FROM `admin_tlqn2021`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.* FROM `admin_tlqn2021`.`banners` AS `Banner` WHERE `Banner`.`pos_right` = '1' AND `Banner`.`public` = '1' ORDER BY `Banner`.`modified` desc | 3 | 3 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` IS NULL AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Post`.`title`, `Post`.`slug` FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`know` = '1' ORDER BY `Post`.`modified` desc LIMIT 10 | 5 | 5 | 0 | |
SELECT `Video`.* FROM `admin_tlqn2021`.`videos` AS `Video` WHERE `Video`.`public` = '1' AND `Video`.`sidebar` = '1' ORDER BY `Video`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 3 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 0 | 0 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 13 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 10 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 9 | 9 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 4 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Catpost`.`id`, `Catpost`.`name` FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`search` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Setting`.`id`, `Setting`.`logo`, `Setting`.`slogan`, `Setting`.`hotline`, `Setting`.`email`, `Setting`.`about`, `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`.`footer_info_left`, `Setting`.`footer_info_right`, `Setting`.`app_id`, `Setting`.`pages_id`, `Setting`.`contact_info`, `Setting`.`noti_gov` FROM `admin_tlqn2021`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Counter`.`id`, `Counter`.`ip`, `Counter`.`timeaccess` FROM `admin_tlqn2021`.`counters` AS `Counter` WHERE `ip` = '18.97.14.87' ORDER BY `id` desc LIMIT 1 | 0 | 0 | 15 | maybe slow |
BEGIN | 0 | 0 | 15 | maybe slow |
INSERT INTO `admin_tlqn2021`.`counters` (`ip`, `timeaccess`) VALUES ('18.97.14.87', 1734203541) | 1 | 1 | 0 | |
COMMIT | 1 | 1 | 0 | |
SELECT `Post`.* FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`slide` = '1' ORDER BY `Post`.`modified` desc | 6 | 6 | 0 | |
SELECT `Post`.* FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`hot` = '1' ORDER BY `Post`.`modified` desc | 7 | 7 | 0 | |
SELECT `Post`.* FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`new` = '1' ORDER BY `Post`.`modified` desc | 5 | 5 | 0 | |
SELECT `Post`.* FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`star` = '1' ORDER BY `Post`.`modified` desc LIMIT 4 | 4 | 4 | 0 | |
SELECT `Catimage`.* FROM `admin_tlqn2021`.`catimages` AS `Catimage` WHERE `Catimage`.`public` = '1' ORDER BY `Catimage`.`modified` desc | 5 | 5 | 0 | |
SELECT `Partner`.* FROM `admin_tlqn2021`.`partners` AS `Partner` WHERE `Partner`.`public` = '1' ORDER BY `Partner`.`modified` desc LIMIT 4 | 3 | 3 | 0 | |
SELECT `Slideshow`.* FROM `admin_tlqn2021`.`slideshows` AS `Slideshow` WHERE `Slideshow`.`public` = '1' ORDER BY `Slideshow`.`modified` desc | 13 | 13 | 0 | |
SELECT `Banner`.* FROM `admin_tlqn2021`.`banners` AS `Banner` WHERE `Banner`.`pos_main` = '1' AND `Banner`.`public` = '1' ORDER BY `Banner`.`modified` desc | 0 | 0 | 0 | |
SELECT `Banner`.* FROM `admin_tlqn2021`.`banners` AS `Banner` WHERE `Banner`.`pos_main_footer` = '1' AND `Banner`.`public` = '1' ORDER BY `Banner`.`modified` desc | 0 | 0 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`home` = '1' AND `Catpost`.`type` = 2 ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 5 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 0 | 0 | 0 | |
SELECT `CatpostsPost`.`id`, `CatpostsPost`.`catpost_id`, `CatpostsPost`.`post_id`, `Catpost`.`id`, `Catpost`.`parent_id`, `Catpost`.`lft`, `Catpost`.`rght`, `Catpost`.`name`, `Catpost`.`slug`, `Catpost`.`folder`, `Catpost`.`image`, `Catpost`.`type`, `Catpost`.`public`, `Catpost`.`home`, `Catpost`.`menu`, `Catpost`.`search`, `Catpost`.`des`, `Catpost`.`content`, `Catpost`.`order`, `Catpost`.`titleseo`, `Catpost`.`description`, `Catpost`.`keywords`, `Catpost`.`created`, `Catpost`.`modified`, `Post`.`id`, `Post`.`catpost_id`, `Post`.`title`, `Post`.`slug`, `Post`.`image`, `Post`.`des`, `Post`.`content`, `Post`.`public`, `Post`.`hot`, `Post`.`star`, `Post`.`slide`, `Post`.`new`, `Post`.`know`, `Post`.`titleseo`, `Post`.`description`, `Post`.`keywords`, `Post`.`created`, `Post`.`modified` FROM `admin_tlqn2021`.`catposts_posts` AS `CatpostsPost` LEFT JOIN `admin_tlqn2021`.`catposts` AS `Catpost` ON (`CatpostsPost`.`catpost_id` = `Catpost`.`id`) LEFT JOIN `admin_tlqn2021`.`posts` AS `Post` ON (`CatpostsPost`.`post_id` = `Post`.`id`) WHERE `CatpostsPost`.`catpost_id` = (5) LIMIT 7 | 4 | 4 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 4 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `CatpostsPost`.`id`, `CatpostsPost`.`catpost_id`, `CatpostsPost`.`post_id`, `Catpost`.`id`, `Catpost`.`parent_id`, `Catpost`.`lft`, `Catpost`.`rght`, `Catpost`.`name`, `Catpost`.`slug`, `Catpost`.`folder`, `Catpost`.`image`, `Catpost`.`type`, `Catpost`.`public`, `Catpost`.`home`, `Catpost`.`menu`, `Catpost`.`search`, `Catpost`.`des`, `Catpost`.`content`, `Catpost`.`order`, `Catpost`.`titleseo`, `Catpost`.`description`, `Catpost`.`keywords`, `Catpost`.`created`, `Catpost`.`modified`, `Post`.`id`, `Post`.`catpost_id`, `Post`.`title`, `Post`.`slug`, `Post`.`image`, `Post`.`des`, `Post`.`content`, `Post`.`public`, `Post`.`hot`, `Post`.`star`, `Post`.`slide`, `Post`.`new`, `Post`.`know`, `Post`.`titleseo`, `Post`.`description`, `Post`.`keywords`, `Post`.`created`, `Post`.`modified` FROM `admin_tlqn2021`.`catposts_posts` AS `CatpostsPost` LEFT JOIN `admin_tlqn2021`.`catposts` AS `Catpost` ON (`CatpostsPost`.`catpost_id` = `Catpost`.`id`) LEFT JOIN `admin_tlqn2021`.`posts` AS `Post` ON (`CatpostsPost`.`post_id` = `Post`.`id`) WHERE `CatpostsPost`.`catpost_id` IN (37, 11, 8, 7, 9, 4) LIMIT 7 | 7 | 7 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 21 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 0 | 0 | 0 | |
SELECT `CatpostsPost`.`id`, `CatpostsPost`.`catpost_id`, `CatpostsPost`.`post_id`, `Catpost`.`id`, `Catpost`.`parent_id`, `Catpost`.`lft`, `Catpost`.`rght`, `Catpost`.`name`, `Catpost`.`slug`, `Catpost`.`folder`, `Catpost`.`image`, `Catpost`.`type`, `Catpost`.`public`, `Catpost`.`home`, `Catpost`.`menu`, `Catpost`.`search`, `Catpost`.`des`, `Catpost`.`content`, `Catpost`.`order`, `Catpost`.`titleseo`, `Catpost`.`description`, `Catpost`.`keywords`, `Catpost`.`created`, `Catpost`.`modified`, `Post`.`id`, `Post`.`catpost_id`, `Post`.`title`, `Post`.`slug`, `Post`.`image`, `Post`.`des`, `Post`.`content`, `Post`.`public`, `Post`.`hot`, `Post`.`star`, `Post`.`slide`, `Post`.`new`, `Post`.`know`, `Post`.`titleseo`, `Post`.`description`, `Post`.`keywords`, `Post`.`created`, `Post`.`modified` FROM `admin_tlqn2021`.`catposts_posts` AS `CatpostsPost` LEFT JOIN `admin_tlqn2021`.`catposts` AS `Catpost` ON (`CatpostsPost`.`catpost_id` = `Catpost`.`id`) LEFT JOIN `admin_tlqn2021`.`posts` AS `Post` ON (`CatpostsPost`.`post_id` = `Post`.`id`) WHERE `CatpostsPost`.`catpost_id` = (21) LIMIT 7 | 7 | 7 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 39 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 0 | 0 | 0 | |
SELECT `CatpostsPost`.`id`, `CatpostsPost`.`catpost_id`, `CatpostsPost`.`post_id`, `Catpost`.`id`, `Catpost`.`parent_id`, `Catpost`.`lft`, `Catpost`.`rght`, `Catpost`.`name`, `Catpost`.`slug`, `Catpost`.`folder`, `Catpost`.`image`, `Catpost`.`type`, `Catpost`.`public`, `Catpost`.`home`, `Catpost`.`menu`, `Catpost`.`search`, `Catpost`.`des`, `Catpost`.`content`, `Catpost`.`order`, `Catpost`.`titleseo`, `Catpost`.`description`, `Catpost`.`keywords`, `Catpost`.`created`, `Catpost`.`modified`, `Post`.`id`, `Post`.`catpost_id`, `Post`.`title`, `Post`.`slug`, `Post`.`image`, `Post`.`des`, `Post`.`content`, `Post`.`public`, `Post`.`hot`, `Post`.`star`, `Post`.`slide`, `Post`.`new`, `Post`.`know`, `Post`.`titleseo`, `Post`.`description`, `Post`.`keywords`, `Post`.`created`, `Post`.`modified` FROM `admin_tlqn2021`.`catposts_posts` AS `CatpostsPost` LEFT JOIN `admin_tlqn2021`.`catposts` AS `Catpost` ON (`CatpostsPost`.`catpost_id` = `Catpost`.`id`) LEFT JOIN `admin_tlqn2021`.`posts` AS `Post` ON (`CatpostsPost`.`post_id` = `Post`.`id`) WHERE `CatpostsPost`.`catpost_id` = (39) LIMIT 7 | 7 | 7 | 0 | |
SELECT COUNT(*) AS `count` FROM `admin_tlqn2021`.`counters` AS `Counter` WHERE 1 = 1 | 1 | 1 | 7 | maybe slow |
SELECT `Setting`.* FROM `admin_tlqn2021`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.* FROM `admin_tlqn2021`.`banners` AS `Banner` WHERE `Banner`.`pos_right` = '1' AND `Banner`.`public` = '1' ORDER BY `Banner`.`modified` desc | 3 | 3 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` IS NULL AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Post`.`title`, `Post`.`slug` FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`know` = '1' ORDER BY `Post`.`modified` desc LIMIT 10 | 5 | 5 | 0 | |
SELECT `Video`.* FROM `admin_tlqn2021`.`videos` AS `Video` WHERE `Video`.`public` = '1' AND `Video`.`sidebar` = '1' ORDER BY `Video`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 3 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 0 | 0 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 13 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 10 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 9 | 9 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 4 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Catpost`.`id`, `Catpost`.`name` FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`search` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Insertcode`.`id`, `Insertcode`.`user_id`, `Insertcode`.`title`, `Insertcode`.`content`, `Insertcode`.`public`, `Insertcode`.`pos_top`, `Insertcode`.`pos_footer`, `Insertcode`.`created`, `Insertcode`.`modified` FROM `admin_tlqn2021`.`insertcodes` AS `Insertcode` WHERE `Insertcode`.`pos_top` = '1' AND `Insertcode`.`public` = '1' | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `admin_tlqn2021`.`counters` AS `Counter` WHERE 1 = 1 | 1 | 1 | 7 | maybe slow |
SELECT `Setting`.* FROM `admin_tlqn2021`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.* FROM `admin_tlqn2021`.`banners` AS `Banner` WHERE `Banner`.`pos_right` = '1' AND `Banner`.`public` = '1' ORDER BY `Banner`.`modified` desc | 3 | 3 | 1 | maybe slow |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` IS NULL AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Post`.`title`, `Post`.`slug` FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`know` = '1' ORDER BY `Post`.`modified` desc LIMIT 10 | 5 | 5 | 0 | |
SELECT `Video`.* FROM `admin_tlqn2021`.`videos` AS `Video` WHERE `Video`.`public` = '1' AND `Video`.`sidebar` = '1' ORDER BY `Video`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 3 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 0 | 0 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 13 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 10 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 9 | 9 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 4 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Catpost`.`id`, `Catpost`.`name` FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`search` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Insertcode`.`id`, `Insertcode`.`user_id`, `Insertcode`.`title`, `Insertcode`.`content`, `Insertcode`.`public`, `Insertcode`.`pos_top`, `Insertcode`.`pos_footer`, `Insertcode`.`created`, `Insertcode`.`modified` FROM `admin_tlqn2021`.`insertcodes` AS `Insertcode` WHERE `Insertcode`.`pos_footer` = '1' AND `Insertcode`.`public` = '1' | 0 | 0 | 0 | |
23 duplicate queries run.