SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545239 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545239 [ RunTime:0.004745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664080,1030033,421142,431834,833776,183079,537208,1038354,966778,35159,620537,172406,835817,943360,832304,552972,769722,835807,526168,410756,517290,222397,880814,155960,692769,215108,98396,181648,376098,792620,382262,591545,460362,997562,395412,531280,572947,108743,686182,797869,3442,852295,124038,733097,915598,710172,802809,41867,784318,455750,863288,195781,582230,54060,633261,693976,469812,752141,450749,369566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]