SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101617 LIMIT 1 [ RunTime:0.005217s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101617 [ RunTime:0.002440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704818,838681,207157,884689,411963,377493,683116,148864,29240,820337,636332,676521,381559,291247,620210,374558,5895,822973,547210,88663,801269,473314,446186,519407,458895,262057,938476,980656,921333,757245,173308,901535,710411,270447,760554,725731,905676,205561,577724,413905,833635,616125,492113,532233,350839,288556,199271,75956,247069,673184,282123,472872,773190,224444,75771,806549,125829,608320,858419,570460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]