SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289012 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289012 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251793,841877,296491,667970,129615,414344,602857,672797,891060,514659,413527,698985,246147,767618,921935,26029,766546,514293,576777,534648,217334,381202,337096,671695,222902,369200,185809,534914,337984,399147,880623,801450,422377,799093,53709,825740,33919,624096,1002348,966987,291899,932850,264640,67112,626597,660508,480610,441304,361740,809885,252579,21744,879494,878516,58116,633071,466557,653484,525129,545644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]