SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465807 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465807 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555700,993095,586843,268941,866249,197395,262435,310752,234806,36736,3911,885099,898503,950715,471695,109720,14397,953934,62145,48415,743282,722367,470424,795961,1004632,886146,81963,991653,573439,927283,487471,361859,489089,140849,961025,541390,58516,184599,435041,278158,100841,10118,293705,197730,57881,413080,712568,221263,175062,134679,304027,758567,966304,643376,629520,848881,725193,301864,218319,1009574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]