SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503169 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503169 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962608,792741,3041,1010975,622816,58752,784509,513992,324700,112724,673068,373117,661329,962981,577481,512115,948469,725732,850581,336806,1032644,686736,1046507,783615,504680,728577,845686,600480,112614,194023,1015599,12393,429512,643418,874719,878935,38851,528986,152413,45618,183246,721520,397432,1013946,551715,373499,541993,128403,885046,826580,146870,242712,991002,572134,315141,124737,970848,972115,204698,508403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]