SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391251 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391251 [ RunTime:0.002584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600780,664768,930779,532496,407396,637521,207133,478846,105946,11210,427460,360260,606627,64968,594456,873161,612005,284517,644613,630558,571248,172435,146101,274188,133971,111259,954733,649660,358752,848032,316146,224682,944574,492852,53756,891237,447752,773133,925074,122638,636734,403739,993833,702638,305481,647673,231750,998428,208466,13907,783772,694764,481348,585820,995058,483780,219175,1046241,480551,682023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]