SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102833 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102833 [ RunTime:0.003499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841546,419409,210654,566621,444139,592186,693924,202216,1032719,777890,361551,116911,981525,45228,625637,127410,284120,889993,662917,726015,1021682,286817,353022,1003884,724460,941550,448839,442451,28941,952081,389321,586217,7712,10487,885010,933305,588507,131468,446891,723078,895586,300472,809829,545323,821392,377822,37319,176924,536190,786954,742423,71536,156663,745382,899631,385748,798760,898276,596863,243872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002449s ]