| 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 '%tro%') OR (`Article`.`tags` LIKE '%tro%') OR (`Article`.`tags_alias` LIKE '%tro%')) ORDER BY `Article`.`updated_at` DESC LIMIT 30, 30 | | 1 | 1 | 2 |
| 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 '%tro%') OR (`Article`.`tags` LIKE '%tro%') OR (`Article`.`tags_alias` LIKE '%tro%')) | | 1 | 1 | 1 |
| 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 `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 NOT (`Category`.`id` IN (1, 2, 6, 11, 17, 18)) AND `Category`.`id` IN (3, 4, 20) ORDER BY `Category`.`id` ASC LIMIT 3 | | 2 | 2 | 0 |
| 6 | 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 NOT (`Category`.`id` IN (1, 2, 3, 4, 6, 11, 17, 18, 20)) ORDER BY RAND() ASC LIMIT 3 | | 3 | 3 | 1 |
| 7 | 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 |
| 8 | 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` = 10 GROUP BY `CategoryLabel`.`label_id` ORDER BY `CategoryLabel`.`ordering` ASC | | 1 | 1 | 0 |
| 9 | 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` = (11) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 0 |
| 10 | 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 |
| 11 | 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` = (7) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 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` = 4 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` <> 0 AND `ArticleLabel`.`label_id` = (4) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3 | | 3 | 3 | 0 |
| 14 | 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 |
| 15 | 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 |
