SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231010 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231010 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015199,19351,515663,856066,918121,434095,71010,457092,492495,319404,1031802,930090,470442,669325,487329,912863,304006,394206,51621,965043,62145,1016280,716716,806718,654869,9470,923985,409898,36928,790471,1020577,22600,208063,563080,843002,250509,525441,166054,200544,126124,320702,561852,80932,368139,789787,447206,983694,366639,690933,726960,609695,556370,655285,821259,191842,778652,335417,480499,504808,532364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]