SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440040 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440040 [ RunTime:0.006111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97235,279462,27330,368202,188220,240236,206743,249001,350403,476108,204922,341284,669737,621989,466332,451540,944741,356246,472276,683274,288767,258375,914447,768271,267338,604377,956560,172775,620508,643,281486,825157,737407,812286,471880,34872,87605,719476,215751,918257,902986,869757,645563,659430,887161,58709,943601,45042,235546,822711,101093,44899,927886,255997,550372,1004047,497067,920083,869973,1017451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]