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-duc' LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `chophutung_db`.`tags` AS `Tag` WHERE `Tag`.`id` = 86 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `chophutung_db`.`tags` AS `Tag` WHERE `Tag`.`id` = 86 | 1 | 1 | 0 | |
UPDATE `chophutung_db`.`tags` SET `view` = 2375 WHERE `chophutung_db`.`tags`.`id` = '86' | 1 | 1 | 13 | maybe slow |
SELECT `ProductsTag`.`id`, `ProductsTag`.`product_id` FROM `chophutung_db`.`products_tags` AS `ProductsTag` WHERE `tag_id` = '86' | 164 | 164 | 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 (469, 468, 465, 557, 525, 503, 472, 466, 464, 463, 462, 460, 445, 444, 443, 402, 24, 354, 353, 350, 349, 346, 345, 303, 262, 224, 219, 217, 211, 209, 102, 77, 20, 4, 200, 101, 100, 323, 347, 210, 356, 348, 343, 501, 606, 607, 609, 610, 613, 614, 616, 618, 621, 611, 320, 58, 46, 634, 637, 648, 655, 657, 660, 681, 677, 352, 30, 685, 686, 692, 703, 684, 683, 710, 711, 712, 720, 302, 722, 61, 732, 733, 60, 59, 734, 736, 10, 750, 752, 748, 749, 754, 755, 759, 760, 791, 828, 829, 863, 866, 888, 890, 891, 905, 906, 931, 17, 955, 959, 960, 965, 998, 1041, 1055, 1072, 1074, 1124, 1035, 924, 922, 921, 920, 919, 918, 917, 884, 836, 835, 834, 833, 832, 831, 830, 737, 644, 1179, 1183, 1190, 1202, 1497, 1498, 1499, 1381, 1375, 1356, 1506, 1507, 652, 654, 821, 813, 812, 803, 719, 713, 620, 619, 617, 1583, 1575, 1618, 1617, 1188, 647) ORDER BY `order` asc, `created` desc LIMIT 16 | 16 | 16 | 3 | maybe slow |
SELECT COUNT(*) AS `count` FROM `chophutung_db`.`products` AS `Product` WHERE `Product`.`active` = '1' AND `Product`.`id` IN (469, 468, 465, 557, 525, 503, 472, 466, 464, 463, 462, 460, 445, 444, 443, 402, 24, 354, 353, 350, 349, 346, 345, 303, 262, 224, 219, 217, 211, 209, 102, 77, 20, 4, 200, 101, 100, 323, 347, 210, 356, 348, 343, 501, 606, 607, 609, 610, 613, 614, 616, 618, 621, 611, 320, 58, 46, 634, 637, 648, 655, 657, 660, 681, 677, 352, 30, 685, 686, 692, 703, 684, 683, 710, 711, 712, 720, 302, 722, 61, 732, 733, 60, 59, 734, 736, 10, 750, 752, 748, 749, 754, 755, 759, 760, 791, 828, 829, 863, 866, 888, 890, 891, 905, 906, 931, 17, 955, 959, 960, 965, 998, 1041, 1055, 1072, 1074, 1124, 1035, 924, 922, 921, 920, 919, 918, 917, 884, 836, 835, 834, 833, 832, 831, 830, 737, 644, 1179, 1183, 1190, 1202, 1497, 1498, 1499, 1381, 1375, 1356, 1506, 1507, 652, 654, 821, 813, 812, 803, 719, 713, 620, 619, 617, 1583, 1575, 1618, 1617, 1188, 647) | 1 | 1 | 1 | |
SELECT `PostsTag`.`id`, `PostsTag`.`post_id` FROM `chophutung_db`.`posts_tags` AS `PostsTag` WHERE `tag_id` = '86' | 7 | 7 | 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 (132, 118, 104, 101, 149, 58, 182) ORDER BY `Post`.`order` asc, `Post`.`created` desc LIMIT 12 | 7 | 7 | 1 | maybe slow |