SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331546 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331546 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515227,709942,620926,787975,268041,843477,416067,985421,364062,874081,249209,944978,838090,935981,783881,708124,441824,455734,741208,1000279,475674,376743,554533,618512,552064,251758,1031386,723711,588301,512439,394642,40854,733743,210151,176931,836462,469709,138471,879237,825818,569700,207632,182795,23164,677552,1024610,118391,404554,95342,635748,728441,38694,845729,680822,929340,972838,640519,4520,950722,329533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]