SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310833 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310833 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457677,1014041,199349,297806,936244,147108,261857,693319,303081,117085,17886,104481,875370,317543,68026,594536,144529,903982,124978,126819,887030,398410,292081,366325,245025,953440,744483,1015543,453973,116882,923710,848168,694727,375964,378219,785074,703163,831792,152968,1011507,628835,239998,939296,882567,540576,985642,991723,308149,394094,216911,129556,387539,979973,711505,537168,292341,362476,664406,298719,48865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]