SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5313 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5313 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219587,638335,256619,927787,508283,698236,379792,1010109,578900,222889,29217,375110,774502,226530,637944,434317,725919,682550,97551,444057,599741,371995,286627,325767,987699,469981,665012,676225,150161,203678,470301,617249,14044,937946,643111,509575,444124,279880,775730,732183,203182,989702,460689,740517,525813,623598,1008675,308306,689594,819406,535847,494678,966729,410806,452516,329797,107410,285229,441600,486176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004242s ]