Tăng hiệu quả kinh doanh với chat chủ động
Tăng hiệu quả kinh doanh với chat chủ động
Để hiểu rõ vấn đề của chính website mình, bạn hãy cùng Chat nhanh kiểm chứng qua các kịch bản sau đây: Thử tưởng tượng bạn bước vào một cửa hàng và không thấy bất kỳ một nhân viên nào ở đấy. Để yêu cầu sự hỗ trợ, bạn phải chủ động đi tìm họ. Cảm giác của bạn thế nào? Câu chuyện tương tự với trải...
(default) 14 queries took 9 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 `congtyinnh_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 `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 '%chat-nhanh%') OR (`Article`.`tags` LIKE '%chat nhanh%') OR (`Article`.`tags_alias` LIKE '%chat-nhanh%')) ORDER BY `Article`.`updated_at` DESC LIMIT 30115
3SELECT 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 '%chat-nhanh%') OR (`Article`.`tags` LIKE '%chat nhanh%') OR (`Article`.`tags_alias` LIKE '%chat-nhanh%'))111
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 `congtyinnh_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 `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 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 `congtyinnh_db`.`categories` AS `Category` WHERE NOT (`Category`.`id` IN (1, 2, 3, 4, 6, 11, 17, 18, 20)) ORDER BY RAND() ASC LIMIT 3331
7SELECT `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 3331
8SELECT `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` ASC110
9SELECT `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 3331
10SELECT `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 3220
11SELECT `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` ASC110
12SELECT `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 3330
13SELECT `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` ASC110
14SELECT `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 3330