SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440156 LIMIT 1 [ RunTime:0.001285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440156 [ RunTime:0.006708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575469,152654,196502,575119,11166,108415,239411,362281,351505,322734,11802,478062,490205,25415,833070,2608,107809,404752,755272,718080,64602,487988,468193,897851,398458,912681,159687,382586,194273,897391,689500,687181,588383,153942,173554,296383,644064,986962,35372,317687,1025335,105460,679283,39305,767189,456034,988472,747505,673778,45439,381602,534762,242842,163926,89436,224953,835896,1003607,668089,886623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001130s ]