| 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 `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 `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`.`alias` LIKE '%dong-co%') OR (`Article`.`tags` LIKE '%dong co%') OR (`Article`.`tags_alias` LIKE '%dong-co%')) ORDER BY `Article`.`updated_at` DESC LIMIT 30 | | 2 | 2 | 7 |
| 3 | 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`.`alias` LIKE '%dong-co%') OR (`Article`.`tags` LIKE '%dong co%') OR (`Article`.`tags_alias` LIKE '%dong-co%')) | | 1 | 1 | 4 |
| 4 | 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 |
| 5 | 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 |
| 6 | 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` <> 0 AND `ArticleLabel`.`label_id` = (9) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 1 |
| 7 | 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 |
| 8 | 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` <> 0 AND `ArticleLabel`.`label_id` = (5) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 2 | 2 | 1 |
| 9 | 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` = 12 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
| 10 | 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` <> 0 AND `ArticleLabel`.`label_id` = (14) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 0 |
| 11 | 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 |
| 12 | 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` <> 0 AND `ArticleLabel`.`label_id` = (4) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 0 |
| 13 | 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 |
| 14 | 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` <> 0 AND `ArticleLabel`.`label_id` = (3) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 0 |
