1 | SELECT `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 1 | | 1 | 1 | 0 |
2 | SELECT `Article`.`id`, `Article`.`category_id`, `Article`.`sub_category_id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`description`, `Article`.`tags`, `Article`.`tags_alias`, `Article`.`source`, `Article`.`views`, `Article`.`is_published`, `Article`.`is_slider`, `Article`.`is_hot`, `Article`.`is_focus`, `Article`.`is_user_post`, `Article`.`created_at`, `Article`.`created_by`, `Article`.`created_ip`, `Article`.`updated_at`, `Article`.`updated_by`, `Article`.`updated_ip`, `Article`.`tags_recommended`, `Creator`.`id`, `Creator`.`username`, `Creator`.`avatar`, `Creator`.`status`, `Creator`.`homepage_link`, `Creator`.`user_type`, `Creator`.`created_at`, `Updator`.`id`, `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`.`id` = 74 AND `Article`.`is_published` = 1 LIMIT 1 | | 1 | 1 | 1 |
3 | SELECT `Article`.`id`, `Article`.`category_id`, `Article`.`sub_category_id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`description`, `Article`.`tags`, `Article`.`tags_alias`, `Article`.`source`, `Article`.`views`, `Article`.`is_published`, `Article`.`is_slider`, `Article`.`is_hot`, `Article`.`is_focus`, `Article`.`is_user_post`, `Article`.`created_at`, `Article`.`created_by`, `Article`.`created_ip`, `Article`.`updated_at`, `Article`.`updated_by`, `Article`.`updated_ip`, `Article`.`tags_recommended`, `Creator`.`id`, `Creator`.`username`, `Creator`.`avatar`, `Creator`.`status`, `Creator`.`homepage_link`, `Creator`.`user_type`, `Creator`.`created_at`, `Updator`.`id`, `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`.`tags_alias` LIKE '%ky-nang-noi-truoc-dam-dong%' ORDER BY `Article`.`id` DESC LIMIT 5 | | 5 | 5 | 2 |
4 | SELECT COUNT(*) AS `count` FROM `kynanggiao_db`.`articles` AS `Article` WHERE `Article`.`id` = 74 | | 1 | 1 | 0 |
5 | SELECT COUNT(*) AS `count` FROM `kynanggiao_db`.`articles` AS `Article` WHERE `Article`.`id` = 74 | | 1 | 1 | 0 |
6 | SELECT COUNT(*) AS `count` FROM `kynanggiao_db`.`articles` AS `Article` WHERE `Article`.`id` = 74 | | 1 | 1 | 0 |
7 | UPDATE `kynanggiao_db`.`articles` SET `id` = 74, `views` = 1310 WHERE `kynanggiao_db`.`articles`.`id` = 74 | | 1 | 1 | 2 |
8 | SELECT 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`.`is_published` = 1 AND `Article`.`created_by` = 19 | | 1 | 1 | 1 |
9 | SELECT 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`.`created_by` = 19 | | 1 | 1 | 0 |
10 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`created_at` 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`.`is_published` = 1 AND `Article`.`created_by` = 19 ORDER BY `Article`.`id` DESC LIMIT 8 | | 8 | 8 | 1 |
11 | SELECT `ArticleLabel`.`id`, `ArticleLabel`.`article_id`, `ArticleLabel`.`label_id`, `Label`.`id`, `Label`.`title`, `Label`.`alias`, `Label`.`slug`, `Label`.`is_recommended`, `Label`.`is_area`, `Label`.`is_source` 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 `ArticleLabel`.`article_id` = 74 | | 1 | 1 | 1 |
12 | SELECT `Label`.`id`, `Label`.`title`, `Label`.`alias`, `Label`.`slug`, `Label`.`total`, `Label`.`is_recommended`, `Label`.`is_area`, `Label`.`is_source`, `Label`.`created_at`, `Label`.`created_ip`, `Label`.`updated_at`, `Label`.`updated_ip` FROM `kynanggiao_db`.`labels` AS `Label` WHERE `Label`.`id` = 605 LIMIT 1 | | 0 | 0 | 0 |
13 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at`, `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`, `Label`.`id`, `Label`.`title`, `Label`.`alias`, `Label`.`slug`, `Label`.`total`, `Label`.`is_recommended`, `Label`.`is_area`, `Label`.`is_source`, `Label`.`created_at`, `Label`.`created_ip`, `Label`.`updated_at`, `Label`.`updated_ip` FROM `kynanggiao_db`.`categories_labels` AS `CategoryLabel` LEFT JOIN `kynanggiao_db`.`categories` AS `Category` ON (`CategoryLabel`.`category_id` = `Category`.`id`) LEFT JOIN `kynanggiao_db`.`labels` AS `Label` ON (`CategoryLabel`.`label_id` = `Label`.`id`) WHERE `CategoryLabel`.`label_id` = (2) GROUP BY `CategoryLabel`.`category_id` ORDER BY `Category`.`ordering` ASC | | 1 | 1 | 0 |
14 | SELECT `Comment`.`id`, `Comment`.`index`, `Comment`.`article_id`, `Comment`.`description`, `Comment`.`is_published`, `Comment`.`created_at`, `Comment`.`created_by`, `Comment`.`created_ip`, `Comment`.`published_at`, `Comment`.`published_by`, `Comment`.`published_ip`, `Comment`.`updated_at`, `Comment`.`updated_by`, `Comment`.`updated_ip`, `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Creator`.`id`, `Creator`.`username`, `Creator`.`avatar`, `Creator`.`status`, `Creator`.`homepage_link`, `Updator`.`id`, `Updator`.`username`, `Updator`.`avatar`, `Updator`.`status`, `Updator`.`homepage_link` FROM `kynanggiao_db`.`comments` AS `Comment` LEFT JOIN `kynanggiao_db`.`articles` AS `Article` ON (`Comment`.`article_id` = `Article`.`id`) LEFT JOIN `kynanggiao_db`.`users` AS `Creator` ON (`Comment`.`created_by` = `Creator`.`id`) LEFT JOIN `kynanggiao_db`.`users` AS `Updator` ON (`Comment`.`updated_by` = `Updator`.`id`) WHERE `Comment`.`article_id` = 74 AND `Comment`.`is_published` = 1 ORDER BY `Comment`.`id` DESC LIMIT 5 | | 0 | 0 | 1 |
15 | SELECT COUNT(*) AS `count` FROM `kynanggiao_db`.`comments` AS `Comment` LEFT JOIN `kynanggiao_db`.`articles` AS `Article` ON (`Comment`.`article_id` = `Article`.`id`) LEFT JOIN `kynanggiao_db`.`users` AS `Creator` ON (`Comment`.`created_by` = `Creator`.`id`) LEFT JOIN `kynanggiao_db`.`users` AS `Updator` ON (`Comment`.`updated_by` = `Updator`.`id`) WHERE `Comment`.`article_id` = 74 AND `Comment`.`is_published` = 1 | | 1 | 1 | 0 |
16 | SELECT `FbComment`.`id`, `FbComment`.`index`, `FbComment`.`article_id`, `FbComment`.`facebook_comment_id`, `FbComment`.`url`, `FbComment`.`message`, `FbComment`.`from`, `FbComment`.`is_published`, `FbComment`.`created_at`, `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Creator`.`id`, `Creator`.`facebook_id`, `Creator`.`name` FROM `kynanggiao_db`.`fb_comments` AS `FbComment` LEFT JOIN `kynanggiao_db`.`articles` AS `Article` ON (`FbComment`.`article_id` = `Article`.`id`) LEFT JOIN `kynanggiao_db`.`fb_users` AS `Creator` ON (`FbComment`.`from` = `Creator`.`id`) WHERE `FbComment`.`article_id` = 74 AND `FbComment`.`is_published` = 1 ORDER BY `FbComment`.`id` DESC LIMIT 30 | | 0 | 0 | 1 |
17 | SELECT `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 1 | | 1 | 1 | 0 |
18 | SELECT `ArticleLabel`.`id`, `ArticleLabel`.`article_id`, `ArticleLabel`.`label_id`, `ArticleLabel`.`created_at` FROM `kynanggiao_db`.`articles_labels` AS `ArticleLabel` WHERE `ArticleLabel`.`article_id` = 74 GROUP BY `ArticleLabel`.`label_id` | | 1 | 1 | 1 |
19 | SELECT `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` <> 74 AND `ArticleLabel`.`label_id` = (2) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 5 | | 5 | 5 | 1 |
20 | SELECT `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 1 | | 1 | 1 | 0 |
21 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` 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`.`is_published` = 1 AND `Article`.`id` <> 74 AND NOT (`Article`.`id` IN (107, 76, 75, 20, 19)) ORDER BY `Article`.`id` DESC LIMIT 5 | | 5 | 5 | 1 |
22 | SELECT `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 1 | | 1 | 1 | 0 |
23 | SELECT `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 `Category`.`id` = 2 LIMIT 1 | | 1 | 1 | 0 |
24 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `kynanggiao_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 2 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
25 | SELECT `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` <> 2 AND `ArticleLabel`.`label_id` = (2) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 1 |
26 | SELECT `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 `Category`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
27 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `kynanggiao_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 1 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
28 | SELECT `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` <> 1 AND `ArticleLabel`.`label_id` = (1) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 1 |
29 | SELECT `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 `Category`.`id` = 3 LIMIT 1 | | 1 | 1 | 0 |
30 | SELECT `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` <> 3 AND `ArticleLabel`.`label_id` = (3) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 1 |
31 | SELECT `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 `Category`.`id` = 4 LIMIT 1 | | 1 | 1 | 0 |
32 | SELECT `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` <> 4 AND `ArticleLabel`.`label_id` = (4) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 1 |
33 | SELECT `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 `Category`.`id` = 5 LIMIT 1 | | 1 | 1 | 0 |
34 | SELECT `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` <> 5 AND `ArticleLabel`.`label_id` = (5) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 2 |
35 | SELECT `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 `Category`.`id` = 6 LIMIT 1 | | 0 | 0 | 0 |
36 | SELECT `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 `Category`.`id` = 7 LIMIT 1 | | 0 | 0 | 0 |
37 | SELECT `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 `Category`.`id` = 8 LIMIT 1 | | 0 | 0 | 0 |
38 | SELECT `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 1 | | 1 | 1 | 0 |