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 10 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-ban-hang%') OR (`Article`.`tags` LIKE '%chat nhanh ban hang%') OR (`Article`.`tags_alias` LIKE '%chat-nhanh-ban-hang%')) 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-ban-hang%') OR (`Article`.`tags` LIKE '%chat nhanh ban hang%') OR (`Article`.`tags_alias` LIKE '%chat-nhanh-ban-hang%'))112
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 3332
7SELECT `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
8SELECT `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
9SELECT `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` ASC110
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` = (14) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3330
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` = 7 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` = (7) GROUP BY `ArticleLabel`.`article_id` ORDER BY `Article`.`id` DESC LIMIT 3330
13SELECT `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
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