SHOW FULL COLUMNS FROM `tool_category` [ RunTime:0.001120s ]
SELECT `id`,`name`,`nickname`,`pid` FROM `tool_category` WHERE `type` = 'tool' AND `status` = 'normal' AND `pid` <> 0 ORDER BY `views` DESC LIMIT 24 [ RunTime:0.001589s ]
SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 703271 LIMIT 1 [ RunTime:0.000669s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 703271 [ RunTime:0.002797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787034,805076,794869,228586,695618,833445,759943,14820,506196,935935,405209,943295,628040,1038586,320357,108796,611655,619182,653077,339148,317332,681070,662234,938054,63397,130479,428797,318715,127417,225845,214030,44294,203659,436056,174102,350070,572499,271849,638006,565242,655012,661697,411514,765879,42446,843018,432255,216702,910141,394936,142206,337557,898103,913473,78659,168759,229709,422387,922680,310609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 703271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 703271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001160s ]