SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010416 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010416 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417546,1033084,654172,19291,519596,171989,802250,209619,660871,26939,255572,661352,296189,650663,342797,930764,304207,214335,240329,553778,1038785,710621,841590,347252,758187,96875,562941,832926,469669,734741,550219,23205,437725,51235,840156,444219,257009,945670,430394,803715,793757,862722,127366,505014,120463,529428,21518,194915,859460,559041,751930,657204,629790,202102,488020,758841,894662,832088,425866,747463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]