SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500680 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500680 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807501,321391,458053,375529,235944,140360,904270,52344,765740,94560,98339,753595,518366,428517,258392,706424,611244,743602,314686,1010719,329816,838225,234932,340409,36114,952551,86452,141858,973654,336464,526006,597935,120787,26573,176396,1012589,320941,265483,282994,576689,626,799026,870997,861469,509292,873444,725694,955781,372910,47932,102489,683752,918809,872445,300457,784009,712527,104591,877519,696932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]