SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109030 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109030 [ RunTime:0.002945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926572,419403,25162,627147,851463,138695,807949,608119,209106,895361,660878,885029,834814,133670,856243,542473,968146,1025505,457593,347813,605645,862583,812911,195809,63597,127732,531981,179155,438864,610724,605069,704392,363296,391060,769044,1024428,164478,675966,853756,1024523,359209,591662,182081,892354,361906,218505,791776,286447,530903,57228,799981,49161,662640,500192,981320,658163,1019928,201984,745587,953840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]