SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331510 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331510 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195260,874591,530623,1037729,400658,885231,719924,877483,27120,769343,340334,325482,492187,501798,874417,919010,374072,1041568,620873,287613,47017,853613,1031465,633769,532698,342926,319876,682261,61192,592198,724348,13502,939624,339450,292842,839715,212879,266832,928619,228711,952212,632445,763895,1010606,249825,290965,620393,45221,133531,624354,360826,661427,359628,791414,905821,937279,453732,694392,600856,997781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]