Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Support`.`id`, `Support`.`nick_name`, `Support`.`name`, `Support`.`phone`, `Support`.`active`, `Support`.`type`, `Support`.`created` FROM `chophutung_db`.`supports` AS `Support` WHERE `active` = '1' ORDER BY `type` desc | 0 | 0 | 0 | |
SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`keyword`, `Tag`.`title`, `Tag`.`view`, `Tag`.`order`, `Tag`.`home_page`, `Tag`.`created` FROM `chophutung_db`.`tags` AS `Tag` WHERE `Tag`.`slug` = 'phu-tung-o-to-my' LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `chophutung_db`.`tags` AS `Tag` WHERE `Tag`.`id` = 87 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `chophutung_db`.`tags` AS `Tag` WHERE `Tag`.`id` = 87 | 1 | 1 | 0 | |
UPDATE `chophutung_db`.`tags` SET `view` = 2780 WHERE `chophutung_db`.`tags`.`id` = '87' | 1 | 1 | 46 | maybe slow |
SELECT `ProductsTag`.`id`, `ProductsTag`.`product_id` FROM `chophutung_db`.`products_tags` AS `ProductsTag` WHERE `tag_id` = '87' | 118 | 118 | 1 | |
SELECT `Product`.`id`, `Product`.`rate`, `Product`.`count_rate`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`price`, `Product`.`price_sale`, `Product`.`created`, `Product`.`image`, `Product`.`image_default`, `Product`.`product_category_id`, `Product`.`content_vie` FROM `chophutung_db`.`products` AS `Product` WHERE `Product`.`active` = '1' AND `Product`.`id` IN (499, 537, 536, 535, 508, 506, 505, 504, 442, 441, 440, 436, 432, 405, 404, 403, 328, 286, 251, 230, 215, 212, 149, 147, 74, 6, 567, 568, 569, 69, 254, 82, 325, 304, 317, 361, 305, 255, 330, 109, 603, 105, 625, 638, 22, 36, 38, 39, 206, 12, 765, 779, 790, 804, 805, 854, 856, 214, 300, 144, 78, 991, 993, 1013, 232, 1034, 1060, 1067, 1073, 1093, 1127, 1134, 1066, 1037, 1010, 633, 632, 615, 1024, 978, 977, 602, 731, 930, 1149, 1150, 1162, 1161, 1164, 1182, 1184, 1185, 1191, 1194, 1197, 1198, 1211, 1215, 1301, 1378, 1529, 1537, 1538, 1545, 1059, 1057, 585, 541, 1581, 1584, 1585, 1587, 1588, 1589, 1593, 1153, 1620, 1662) ORDER BY `order` asc, `created` desc LIMIT 16 | 16 | 16 | 2 | maybe slow |
SELECT COUNT(*) AS `count` FROM `chophutung_db`.`products` AS `Product` WHERE `Product`.`active` = '1' AND `Product`.`id` IN (499, 537, 536, 535, 508, 506, 505, 504, 442, 441, 440, 436, 432, 405, 404, 403, 328, 286, 251, 230, 215, 212, 149, 147, 74, 6, 567, 568, 569, 69, 254, 82, 325, 304, 317, 361, 305, 255, 330, 109, 603, 105, 625, 638, 22, 36, 38, 39, 206, 12, 765, 779, 790, 804, 805, 854, 856, 214, 300, 144, 78, 991, 993, 1013, 232, 1034, 1060, 1067, 1073, 1093, 1127, 1134, 1066, 1037, 1010, 633, 632, 615, 1024, 978, 977, 602, 731, 930, 1149, 1150, 1162, 1161, 1164, 1182, 1184, 1185, 1191, 1194, 1197, 1198, 1211, 1215, 1301, 1378, 1529, 1537, 1538, 1545, 1059, 1057, 585, 541, 1581, 1584, 1585, 1587, 1588, 1589, 1593, 1153, 1620, 1662) | 1 | 1 | 1 | |
SELECT `PostsTag`.`id`, `PostsTag`.`post_id` FROM `chophutung_db`.`posts_tags` AS `PostsTag` WHERE `tag_id` = '87' | 2 | 2 | 0 | |
SELECT `Post`.`name_vie`, `Post`.`image`, `Post`.`slug`, `Post`.`id`, `Post`.`content_vie`, `Post`.`created` FROM `chophutung_db`.`posts` AS `Post` WHERE `Post`.`active` = '1' AND `Post`.`id` IN (106, 107) ORDER BY `Post`.`order` asc, `Post`.`created` desc LIMIT 12 | 2 | 2 | 0 | |