SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318814 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318814 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202098,437141,698013,698398,593772,907073,285528,16405,478189,116249,879083,538880,662824,495340,1037620,964080,935259,668419,614126,481414,542063,781012,32998,276299,621984,695654,949600,180129,19419,543063,237905,430100,290338,46030,955032,749318,39970,612581,223629,269381,10683,602202,799625,541228,605628,1036400,458125,1007778,330046,114154,775748,725109,840255,888638,571267,222728,981949,1021457,98390,570584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]