SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519071 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519071 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753383,106282,237813,435120,232597,449948,954730,746526,194006,675593,1002202,30036,611613,546725,112978,713177,348490,670724,575108,31318,624790,546342,208527,104922,31142,250376,1047598,876435,556836,393937,325617,487743,11966,228442,291586,703689,595034,420974,413779,704870,77395,404790,365890,608794,240648,15967,891640,641868,860060,81021,627995,817315,212506,542838,241509,750,867481,483397,610742,806512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]