基本
文件
流程
錯(cuò)誤
SQL
調(diào)試
- 請(qǐng)求信息 : 2025-09-12 04:45:13 HTTP/1.1 GET : http://willane.com/puercha/100332/
- 運(yùn)行時(shí)間 : 0.061153s [ 吞吐率：16.35req/s ] 內(nèi)存消耗：1,333.72kb 文件加載：199
- 查詢信息 : 0 queries
- 緩存信息 : 0 reads,0 writes
- 會(huì)話信息 : SESSION_ID=581a7701e1a46239e29cb69f8c7395ef
- CONNECT:[ UseTime:0.000860s ] mysql:host=127.0.0.1;port=3306;dbname=www_puercn_com;charset=utf8mb4
- SHOW FULL COLUMNS FROM `cms_product_categories` [ RunTime:0.000962s ]
- SELECT * FROM `cms_product_categories` WHERE `pinyin` = 'puercha' LIMIT 1 [ RunTime:0.000589s ]
- SHOW FULL COLUMNS FROM `cms_brand_to_category` [ RunTime:0.000833s ]
- SELECT * FROM `cms_brand_to_category` WHERE `category_id` = 1 [ RunTime:0.000344s ]
- SHOW FULL COLUMNS FROM `cms_brand` [ RunTime:0.000598s ]
- SELECT `id`,`pinyin`,`brandname`,`product_num`,`exchange_num`,`logoname`,`website`,`visits`,`description`,`issearch`,`update_time` FROM `cms_brand` WHERE `id` IN (1,2,26,27,28,29,33,4,7,8,10,11,12,58,45,109,55,65,66,64,54,56,57,63,67,52,51,50,49,48,47,46,25,24,23,22,21,9,19,18,17,16,15,117,119,20,144,145,146,147,148,163,169,170,171,6,172,174,175,177,178,179,181,183,185,186,188,192,193,5,195,196,13,53,60,198,199,201,14,202,204,205,206,190,217,218,219,220,221,212,222,223,224,225,194) AND `id` NOT IN (15,170,119,174,198) ORDER BY `home_sort` DESC,`sort` DESC,`id` ASC [ RunTime:0.001767s ]
- SHOW FULL COLUMNS FROM `cms_product_attribute` [ RunTime:0.000441s ]
- SELECT * FROM `cms_product_attribute` WHERE `category_id` = 1 AND `isshow` = 1 ORDER BY `sort` ASC [ RunTime:0.000314s ]
- SHOW FULL COLUMNS FROM `cms_product_attribute_value` [ RunTime:0.000430s ]
- SELECT * FROM `cms_product_attribute_value` WHERE `isshow` = 1 AND `attribute_id` IN (10039,10000,10001,10002,10003,10004,10005) [ RunTime:0.000462s ]
- SELECT `t1`.`product_id` FROM cms_product_attribute_value_to_product AS t1 USE INDEX(idx_attr_value_product) WHERE `t1`.`attr_value_id` = '100332' GROUP BY `t1`.`product_id` HAVING COUNT(DISTINCT t1.attr_value_id) = 1 LIMIT 0,1000 [ RunTime:0.000664s ]
- SELECT `t1`.`product_id` FROM cms_product_attribute_value_to_product AS t1 USE INDEX(idx_attr_value_product) WHERE `t1`.`attr_value_id` = '100332' GROUP BY `t1`.`product_id` HAVING COUNT(DISTINCT t1.attr_value_id) = 1 LIMIT 1000,1000 [ RunTime:0.000497s ]
- SHOW FULL COLUMNS FROM `cms_product` [ RunTime:0.000546s ]
- CREATE TEMPORARY TABLE cms_temp_product_ids_68c334d9e2692 (prodid INT PRIMARY KEY) ENGINE=MEMORY [ RunTime:0.000704s ]
- SHOW FULL COLUMNS FROM `cms_temp_product_ids_68c334d9e2692` [ RunTime:0.000371s ]
- INSERT INTO `cms_temp_product_ids_68c334d9e2692` (`prodid`) VALUES ( 198 ) , ( 200 ) , ( 277 ) , ( 561 ) , ( 562 ) , ( 563 ) , ( 564 ) , ( 565 ) , ( 566 ) , ( 567 ) , ( 568 ) , ( 569 ) , ( 570 ) , ( 571 ) , ( 572 ) , ( 573 ) , ( 574 ) , ( 575 ) , ( 576 ) , ( 577 ) , ( 578 ) , ( 579 ) , ( 580 ) , ( 581 ) , ( 582 ) , ( 583 ) , ( 584 ) , ( 585 ) , ( 586 ) , ( 587 ) , ( 588 ) , ( 589 ) , ( 590 ) , ( 591 ) , ( 592 ) , ( 593 ) , ( 594 ) , ( 595 ) , ( 596 ) , ( 597 ) , ( 598 ) , ( 599 ) , ( 600 ) , ( 601 ) , ( 602 ) , ( 603 ) , ( 604 ) , ( 605 ) , ( 606 ) , ( 607 ) , ( 608 ) , ( 609 ) , ( 610 ) , ( 723 ) , ( 795 ) , ( 1021 ) , ( 1024 ) , ( 1025 ) , ( 1028 ) , ( 1030 ) , ( 1031 ) , ( 1032 ) , ( 1033 ) , ( 1035 ) , ( 1040 ) , ( 1041 ) , ( 1042 ) , ( 1043 ) , ( 1053 ) , ( 1054 ) , ( 1055 ) , ( 1056 ) , ( 1057 ) , ( 1058 ) , ( 1059 ) , ( 1060 ) , ( 1061 ) , ( 1063 ) , ( 1064 ) , ( 1065 ) , ( 1066 ) , ( 1067 ) , ( 1070 ) , ( 1072 ) , ( 1074 ) , ( 1075 ) , ( 1078 ) , ( 1081 ) , ( 1082 ) , ( 1085 ) , ( 1086 ) , ( 1088 ) , ( 1089 ) , ( 1091 ) , ( 1092 ) , ( 1096 ) , ( 1098 ) , ( 1101 ) , ( 1102 ) , ( 1105 ) , ( 1113 ) , ( 1122 ) , ( 1468 ) , ( 1473 ) , ( 1474 ) , ( 1476 ) , ( 1478 ) , ( 1479 ) , ( 1481 ) , ( 1482 ) , ( 1483 ) , ( 1486 ) , ( 1487 ) , ( 1490 ) , ( 1492 ) , ( 1495 ) , ( 1497 ) , ( 1498 ) , ( 1555 ) , ( 1611 ) , ( 1613 ) , ( 1615 ) , ( 1616 ) , ( 1617 ) , ( 1620 ) , ( 1627 ) , ( 1628 ) , ( 1629 ) , ( 1630 ) , ( 1631 ) , ( 1632 ) , ( 1633 ) , ( 1634 ) , ( 1635 ) , ( 1660 ) , ( 1661 ) , ( 1662 ) , ( 1663 ) , ( 1664 ) , ( 1665 ) , ( 1666 ) , ( 1667 ) , ( 1668 ) , ( 1669 ) , ( 1670 ) , ( 1671 ) , ( 1729 ) , ( 2009 ) , ( 2266 ) , ( 2277 ) , ( 2281 ) , ( 2425 ) , ( 2428 ) , ( 2430 ) , ( 2484 ) , ( 2486 ) , ( 2487 ) , ( 2489 ) , ( 2527 ) , ( 2528 ) , ( 2532 ) , ( 2534 ) , ( 2535 ) , ( 2536 ) , ( 2537 ) , ( 2545 ) , ( 2546 ) , ( 2549 ) , ( 2550 ) , ( 2553 ) , ( 2554 ) , ( 2555 ) , ( 2557 ) , ( 2558 ) , ( 2560 ) , ( 2562 ) , ( 2565 ) , ( 2567 ) , ( 2568 ) , ( 2569 ) , ( 2571 ) , ( 2572 ) , ( 2573 ) , ( 2575 ) , ( 2808 ) , ( 2846 ) , ( 2847 ) , ( 2849 ) , ( 2851 ) , ( 2852 ) , ( 2853 ) , ( 2854 ) , ( 2855 ) , ( 2856 ) , ( 2857 ) , ( 2858 ) , ( 2859 ) , ( 2878 ) , ( 2918 ) , ( 2971 ) , ( 2982 ) , ( 2984 ) , ( 3019 ) , ( 3026 ) , ( 3230 ) , ( 3231 ) , ( 3232 ) , ( 3233 ) , ( 3234 ) , ( 3235 ) , ( 3236 ) , ( 3237 ) , ( 3238 ) , ( 3241 ) , ( 3360 ) , ( 3379 ) , ( 3403 ) , ( 3407 ) , ( 3408 ) , ( 3409 ) , ( 3410 ) , ( 3411 ) , ( 3442 ) , ( 3443 ) , ( 3493 ) , ( 3498 ) , ( 3503 ) , ( 3567 ) , ( 3582 ) , ( 3623 ) , ( 3639 ) , ( 3664 ) , ( 3686 ) , ( 3723 ) , ( 3732 ) , ( 3736 ) , ( 3738 ) , ( 3783 ) , ( 3784 ) , ( 3785 ) , ( 3859 ) , ( 3921 ) , ( 4251 ) , ( 4322 ) , ( 4324 ) , ( 4342 ) , ( 4679 ) , ( 4680 ) , ( 5079 ) , ( 5082 ) , ( 5083 ) , ( 5090 ) , ( 5120 ) , ( 5121 ) , ( 5125 ) , ( 5209 ) , ( 5368 ) , ( 5369 ) , ( 5370 ) , ( 5371 ) , ( 5372 ) , ( 5448 ) , ( 5550 ) , ( 5603 ) , ( 5626 ) , ( 5627 ) , ( 5628 ) , ( 5629 ) , ( 5630 ) , ( 5631 ) , ( 5632 ) , ( 5633 ) , ( 5634 ) , ( 5635 ) , ( 5636 ) , ( 5637 ) , ( 5638 ) , ( 5639 ) , ( 5640 ) , ( 5641 ) , ( 5642 ) , ( 6198 ) , ( 6199 ) , ( 6200 ) , ( 6201 ) , ( 6203 ) , ( 6204 ) , ( 6205 ) , ( 6206 ) , ( 6207 ) , ( 6208 ) , ( 6209 ) , ( 6210 ) , ( 6934 ) , ( 7278 ) , ( 7354 ) , ( 7376 ) , ( 8501 ) , ( 8503 ) , ( 8505 ) , ( 8525 ) , ( 8869 ) , ( 9207 ) , ( 9208 ) , ( 9209 ) , ( 9210 ) , ( 9574 ) , ( 9619 ) , ( 10945 ) , ( 11324 ) , ( 11327 ) , ( 11329 ) , ( 11330 ) , ( 11331 ) , ( 11332 ) , ( 11333 ) , ( 11335 ) , ( 11336 ) , ( 11337 ) , ( 11338 ) , ( 11339 ) , ( 11340 ) , ( 11341 ) , ( 11342 ) , ( 11343 ) , ( 11345 ) , ( 11346 ) , ( 11347 ) , ( 11348 ) , ( 11351 ) , ( 11352 ) , ( 11353 ) , ( 11354 ) , ( 11355 ) , ( 11359 ) , ( 11360 ) , ( 11361 ) , ( 11362 ) , ( 12556 ) , ( 12557 ) , ( 12558 ) , ( 12559 ) , ( 12560 ) , ( 12606 ) , ( 12610 ) , ( 12614 ) , ( 12620 ) , ( 12624 ) , ( 12629 ) , ( 12632 ) , ( 12638 ) , ( 12640 ) , ( 12643 ) , ( 12646 ) , ( 12648 ) , ( 12651 ) , ( 12653 ) , ( 12656 ) , ( 12659 ) , ( 12660 ) , ( 12661 ) , ( 12662 ) , ( 12663 ) , ( 12664 ) , ( 12665 ) , ( 12667 ) , ( 12668 ) , ( 12669 ) , ( 13193 ) , ( 13411 ) , ( 13418 ) , ( 13419 ) , ( 13420 ) , ( 13421 ) , ( 13422 ) , ( 13433 ) , ( 13603 ) , ( 13736 ) , ( 13771 ) , ( 13902 ) , ( 14095 ) , ( 14147 ) , ( 14338 ) , ( 14339 ) , ( 14365 ) , ( 14373 ) , ( 14429 ) , ( 14430 ) , ( 14632 ) , ( 14651 ) , ( 15702 ) , ( 15712 ) , ( 15713 ) , ( 16011 ) , ( 16153 ) , ( 16163 ) , ( 16674 ) , ( 16690 ) , ( 18589 ) , ( 19308 ) , ( 21500 ) , ( 21544 ) , ( 21545 ) , ( 21698 ) , ( 21807 ) , ( 21808 ) , ( 21829 ) , ( 21940 ) , ( 23387 ) , ( 23390 ) , ( 23550 ) , ( 23603 ) , ( 23898 ) , ( 23912 ) , ( 23913 ) , ( 23952 ) , ( 23953 ) , ( 23980 ) , ( 23981 ) , ( 23982 ) , ( 24235 ) , ( 24237 ) , ( 24248 ) , ( 24249 ) , ( 24261 ) , ( 24262 ) , ( 24295 ) , ( 24296 ) , ( 24297 ) , ( 24298 ) , ( 24301 ) , ( 24302 ) , ( 24303 ) , ( 24304 ) , ( 24305 ) , ( 24306 ) , ( 24307 ) , ( 24308 ) , ( 24309 ) , ( 24311 ) , ( 24312 ) , ( 24313 ) , ( 24315 ) , ( 24771 ) , ( 24817 ) , ( 24923 ) , ( 24932 ) , ( 24951 ) , ( 24995 ) , ( 24996 ) , ( 24997 ) , ( 24998 ) , ( 24999 ) , ( 25000 ) , ( 25239 ) , ( 25240 ) , ( 25580 ) , ( 25602 ) , ( 25603 ) , ( 25605 ) , ( 25787 ) , ( 26138 ) , ( 26139 ) , ( 26140 ) , ( 26141 ) , ( 26142 ) , ( 26143 ) , ( 26144 ) , ( 26145 ) , ( 26146 ) , ( 26147 ) , ( 26148 ) , ( 26149 ) , ( 26152 ) , ( 26153 ) , ( 26156 ) , ( 26157 ) , ( 26158 ) , ( 26384 ) , ( 26403 ) , ( 26424 ) , ( 26425 ) , ( 26426 ) , ( 26427 ) , ( 26428 ) , ( 26444 ) , ( 26445 ) , ( 26447 ) , ( 26448 ) , ( 26450 ) , ( 26451 ) , ( 26452 ) , ( 26453 ) , ( 26454 ) , ( 26455 ) , ( 26456 ) , ( 26457 ) , ( 26458 ) , ( 26459 ) , ( 26460 ) [ RunTime:0.002949s ]
- INSERT INTO `cms_temp_product_ids_68c334d9e2692` (`prodid`) VALUES ( 26504 ) , ( 26660 ) , ( 26698 ) , ( 26723 ) , ( 26726 ) , ( 26942 ) , ( 26946 ) , ( 27277 ) , ( 27339 ) , ( 27347 ) , ( 27437 ) , ( 27587 ) [ RunTime:0.000458s ]
- SELECT COUNT(*) AS think_count FROM `cms_product` `products` INNER JOIN `cms_temp_product_ids_68c334d9e2692` `tmp` ON `products`.`id`=`tmp`.`prodid` WHERE ( `category_id` = 1 ) AND `products`.`delete_time` IS NULL [ RunTime:0.001017s ]
- SELECT `id`,`brand_id`,`category_id`,`product_name`,`year`,`netwt`,`unit`,`price`,`last_price`,`cover`,`visits` FROM `cms_product` `products` INNER JOIN `cms_temp_product_ids_68c334d9e2692` `tmp` ON `products`.`id`=`tmp`.`prodid` WHERE ( `category_id` = 1 ) AND `products`.`delete_time` IS NULL ORDER BY `visits` DESC LIMIT 0,40 [ RunTime:0.001570s ]
- SELECT `id`,`name`,`pinyin` FROM `cms_product_categories` WHERE `id` = 1 [ RunTime:0.000237s ]
- SELECT `id`,`brandname`,`logoname`,`pinyin`,`product_num`,`exchange_num`,`description` FROM `cms_brand` WHERE `id` IN (1,11,8,190,17,22) [ RunTime:0.000321s ]
- SELECT `id`,`name`,`pinyin`,`icon`,`pathapp`,`iconapp` FROM `cms_product_categories` WHERE `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000282s ]
- SHOW FULL COLUMNS FROM `cms_column` [ RunTime:0.000422s ]
- SELECT * FROM `cms_column` ORDER BY `id` ASC [ RunTime:0.000556s ]
- SELECT `id`,`name`,`pinyin`,`icon`,`pathapp`,`iconapp` FROM `cms_product_categories` WHERE `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000283s ]
