(default) 12 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Config`.`id`, `Config`.`sitename`, `Config`.`domain`, `Config`.`title`, `Config`.`keywords`, `Config`.`description`, `Config`.`sidebar_module`, `Config`.`footer_module`, `Config`.`content_box`, `Config`.`desktop_footer_image_box`, `Config`.`mobile_footer_image_box`, `Config`.`support_image`, `Config`.`rss`, `Config`.`rss_box`, `Config`.`rss_number` FROM `kynanggiao_db`.`configs` AS `Config` WHERE `Config`.`id` = 99 LIMIT 1110
2SELECT `Article`.`id`, `Article`.`category_id`, `Article`.`sub_category_id`, `Article`.`title`, `Article`.`alias`, `Article`.`description`, `Article`.`thumbnail`, `Article`.`is_published`, `Article`.`is_focus`, `Article`.`is_slider`, `Article`.`is_hot`, `Article`.`updated_at`, `Article`.`updated_by`, `Updator`.`username` FROM `kynanggiao_db`.`articles` AS `Article` LEFT JOIN `kynanggiao_db`.`users` AS `Creator` ON (`Article`.`created_by` = `Creator`.`id`) LEFT JOIN `kynanggiao_db`.`users` AS `Updator` ON (`Article`.`updated_by` = `Updator`.`id`) WHERE `Article`.`description` <> '' AND `Article`.`is_published` = 1 AND ((`Article`.`alias` LIKE '%thanh-ly-cong-cu%') OR (`Article`.`tags` LIKE '%thanh ly cong cu%') OR (`Article`.`tags_alias` LIKE '%thanh-ly-cong-cu%')) ORDER BY `Article`.`updated_at` DESC LIMIT 30003
3SELECT COUNT(*) AS `count` FROM `kynanggiao_db`.`articles` AS `Article` LEFT JOIN `kynanggiao_db`.`users` AS `Creator` ON (`Article`.`created_by` = `Creator`.`id`) LEFT JOIN `kynanggiao_db`.`users` AS `Updator` ON (`Article`.`updated_by` = `Updator`.`id`) WHERE `Article`.`description` <> '' AND `Article`.`is_published` = 1 AND ((`Article`.`alias` LIKE '%thanh-ly-cong-cu%') OR (`Article`.`tags` LIKE '%thanh ly cong cu%') OR (`Article`.`tags_alias` LIKE '%thanh-ly-cong-cu%'))112
4SELECT `Config`.`id`, `Config`.`sitename`, `Config`.`domain`, `Config`.`title`, `Config`.`keywords`, `Config`.`description`, `Config`.`sidebar_module`, `Config`.`footer_module`, `Config`.`content_box`, `Config`.`desktop_footer_image_box`, `Config`.`mobile_footer_image_box`, `Config`.`support_image`, `Config`.`rss`, `Config`.`rss_box`, `Config`.`rss_number` FROM `kynanggiao_db`.`configs` AS `Config` WHERE `Config`.`id` = 99 LIMIT 1110
5SELECT `Category`.`id`, `Category`.`title`, `Category`.`alias`, `Category`.`description`, `Category`.`ordering`, `Category`.`is_menu`, `Category`.`created_at`, `Category`.`created_ip`, `Category`.`updated_at`, `Category`.`updated_ip` FROM `kynanggiao_db`.`categories` AS `Category` WHERE NOT (`Category`.`id` IN (1, 2, 6, 11, 17, 18)) AND `Category`.`id` IN (3, 4, 20) ORDER BY `Category`.`id` ASC LIMIT 3220
6SELECT `Category`.`id`, `Category`.`title`, `Category`.`alias`, `Category`.`description`, `Category`.`ordering`, `Category`.`is_menu`, `Category`.`created_at`, `Category`.`created_ip`, `Category`.`updated_at`, `Category`.`updated_ip` FROM `kynanggiao_db`.`categories` AS `Category` WHERE NOT (`Category`.`id` IN (1, 2, 3, 4, 6, 11, 17, 18, 20)) ORDER BY RAND() ASC LIMIT 3111
7SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `kynanggiao_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 5 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC110
8SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` FROM `kynanggiao_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `kynanggiao_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `kynanggiao_db`.`labels` AS `Label` ON (`ArticleLabel`.`label_id` = `Label`.`id`) WHERE `Article`.`is_published` = 1 AND `ArticleLabel`.`article_id` <> 0 AND `ArticleLabel`.`label_id` = (5) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3332
9SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `kynanggiao_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 4 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC110
10SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` FROM `kynanggiao_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `kynanggiao_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `kynanggiao_db`.`labels` AS `Label` ON (`ArticleLabel`.`label_id` = `Label`.`id`) WHERE `Article`.`is_published` = 1 AND `ArticleLabel`.`article_id` <> 0 AND `ArticleLabel`.`label_id` = (4) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3331
11SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `kynanggiao_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 3 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC110
12SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` FROM `kynanggiao_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `kynanggiao_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `kynanggiao_db`.`labels` AS `Label` ON (`ArticleLabel`.`label_id` = `Label`.`id`) WHERE `Article`.`is_published` = 1 AND `ArticleLabel`.`article_id` <> 0 AND `ArticleLabel`.`label_id` = (3) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3331