| 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 `congtyinnh_db`.`configs` AS `Config` WHERE `Config`.`id` = 99 LIMIT 1 | | 1 | 1 | 0 |
| 2 | 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 `congtyinnh_db`.`categories` AS `Category` WHERE `Category`.`alias` = 'cung-cap-banner-standee' LIMIT 1 | | 1 | 1 | 0 |
| 3 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `congtyinnh_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 2 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
| 4 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`description`, `Article`.`thumbnail` FROM `congtyinnh_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `congtyinnh_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `congtyinnh_db`.`labels` AS `Label` ON (`ArticleLabel`.`label_id` = `Label`.`id`) WHERE `Article`.`is_published` = 1 AND `ArticleLabel`.`label_id` = (2) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 5 | | 5 | 5 | 1 |
| 5 | SELECT `ArticleLabel`.`id`, `ArticleLabel`.`article_id`, `ArticleLabel`.`label_id`, `ArticleLabel`.`created_at` FROM `congtyinnh_db`.`articles_labels` AS `ArticleLabel` WHERE `ArticleLabel`.`label_id` = (2) ORDER BY `ArticleLabel`.`article_id` DESC | | 8 | 8 | 0 |
| 6 | SELECT `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` FROM `congtyinnh_db`.`articles` AS `Article` LEFT JOIN `congtyinnh_db`.`users` AS `Creator` ON (`Article`.`created_by` = `Creator`.`id`) LEFT JOIN `congtyinnh_db`.`users` AS `Updator` ON (`Article`.`updated_by` = `Updator`.`id`) WHERE `Article`.`description` <> '' AND `Article`.`is_published` = 1 AND `Article`.`id` IN (43, 38, 33, 27, 26, 25, 24, 23) ORDER BY `Article`.`updated_at` DESC LIMIT 30 | | 8 | 8 | 0 |
| 7 | SELECT COUNT(*) AS `count` FROM `congtyinnh_db`.`articles` AS `Article` LEFT JOIN `congtyinnh_db`.`users` AS `Creator` ON (`Article`.`created_by` = `Creator`.`id`) LEFT JOIN `congtyinnh_db`.`users` AS `Updator` ON (`Article`.`updated_by` = `Updator`.`id`) WHERE `Article`.`description` <> '' AND `Article`.`is_published` = 1 AND `Article`.`id` IN (43, 38, 33, 27, 26, 25, 24, 23) | | 1 | 1 | 0 |
| 8 | 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 `congtyinnh_db`.`configs` AS `Config` WHERE `Config`.`id` = 99 LIMIT 1 | | 1 | 1 | 0 |
| 9 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`description`, `Article`.`thumbnail` FROM `congtyinnh_db`.`articles` AS `Article` LEFT JOIN `congtyinnh_db`.`users` AS `Creator` ON (`Article`.`created_by` = `Creator`.`id`) LEFT JOIN `congtyinnh_db`.`users` AS `Updator` ON (`Article`.`updated_by` = `Updator`.`id`) WHERE `Article`.`is_published` = 1 AND `Article`.`is_slider` = 0 AND `Article`.`is_hot` = 0 AND `Article`.`is_focus` = 1 ORDER BY `Article`.`id` DESC LIMIT 6 | | 5 | 5 | 0 |
| 10 | 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 `congtyinnh_db`.`configs` AS `Config` WHERE `Config`.`id` = 99 LIMIT 1 | | 1 | 1 | 0 |
| 11 | 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 `congtyinnh_db`.`categories` AS `Category` WHERE `Category`.`id` = 2 LIMIT 1 | | 1 | 1 | 0 |
| 12 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `congtyinnh_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 2 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
| 13 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` FROM `congtyinnh_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `congtyinnh_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `congtyinnh_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 | 0 |
| 14 | 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 `congtyinnh_db`.`categories` AS `Category` WHERE `Category`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 15 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `congtyinnh_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 1 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 2 | 2 | 0 |
| 16 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` FROM `congtyinnh_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `congtyinnh_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `congtyinnh_db`.`labels` AS `Label` ON (`ArticleLabel`.`label_id` = `Label`.`id`) WHERE `Article`.`is_published` = 1 AND `ArticleLabel`.`article_id` <> 1 AND `ArticleLabel`.`label_id` IN (1, 8) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 0 |
| 17 | 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 `congtyinnh_db`.`categories` AS `Category` WHERE `Category`.`id` = 3 LIMIT 1 | | 1 | 1 | 0 |
| 18 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `congtyinnh_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 3 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
| 19 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` FROM `congtyinnh_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `congtyinnh_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `congtyinnh_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 | 0 |
| 20 | 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 `congtyinnh_db`.`categories` AS `Category` WHERE `Category`.`id` = 4 LIMIT 1 | | 1 | 1 | 0 |
| 21 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `congtyinnh_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 4 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
| 22 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` FROM `congtyinnh_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `congtyinnh_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `congtyinnh_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 | 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 `congtyinnh_db`.`categories` AS `Category` WHERE `Category`.`id` = 5 LIMIT 1 | | 1 | 1 | 0 |
| 24 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `congtyinnh_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 5 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 `congtyinnh_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `congtyinnh_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `congtyinnh_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 | | 2 | 2 | 0 |
| 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 `congtyinnh_db`.`categories` AS `Category` WHERE `Category`.`id` = 6 LIMIT 1 | | 1 | 1 | 0 |
| 27 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `congtyinnh_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 6 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 `congtyinnh_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `congtyinnh_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `congtyinnh_db`.`labels` AS `Label` ON (`ArticleLabel`.`label_id` = `Label`.`id`) WHERE `Article`.`is_published` = 1 AND `ArticleLabel`.`article_id` <> 6 AND `ArticleLabel`.`label_id` = (6) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 0 |
| 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 `congtyinnh_db`.`categories` AS `Category` WHERE `Category`.`id` = 7 LIMIT 1 | | 1 | 1 | 0 |
| 30 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `congtyinnh_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 7 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
| 31 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` FROM `congtyinnh_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `congtyinnh_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `congtyinnh_db`.`labels` AS `Label` ON (`ArticleLabel`.`label_id` = `Label`.`id`) WHERE `Article`.`is_published` = 1 AND `ArticleLabel`.`article_id` <> 7 AND `ArticleLabel`.`label_id` = (7) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 0 |
| 32 | 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 `congtyinnh_db`.`categories` AS `Category` WHERE `Category`.`id` = 8 LIMIT 1 | | 1 | 1 | 0 |
| 33 | SELECT `CategoryLabel`.`id`, `CategoryLabel`.`category_id`, `CategoryLabel`.`label_id`, `CategoryLabel`.`ordering`, `CategoryLabel`.`created_at` FROM `congtyinnh_db`.`categories_labels` AS `CategoryLabel` WHERE `CategoryLabel`.`category_id` = 8 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
| 34 | SELECT `Article`.`id`, `Article`.`title`, `Article`.`alias`, `Article`.`thumbnail`, `Article`.`updated_at` FROM `congtyinnh_db`.`articles_labels` AS `ArticleLabel` LEFT JOIN `congtyinnh_db`.`articles` AS `Article` ON (`ArticleLabel`.`article_id` = `Article`.`id`) LEFT JOIN `congtyinnh_db`.`labels` AS `Label` ON (`ArticleLabel`.`label_id` = `Label`.`id`) WHERE `Article`.`is_published` = 1 AND `ArticleLabel`.`article_id` <> 8 AND `ArticleLabel`.`label_id` = (9) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 0 |
| 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 `congtyinnh_db`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`ordering` ASC | | 11 | 11 | 0 |