SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002758s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401087 LIMIT 1 [ RunTime:0.001414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401087 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32384,1003966,14017,998177,986093,26429,302712,553211,240043,902443,31579,121531,93050,823612,273334,414992,671036,737263,613087,562905,570268,568410,546935,512448,455997,445593,409097,911867,540038,769654,461357,185561,696845,143960,622829,770925,15221,926559,926500,13158,459301,482366,219010,403810,489698,24914,1024620,614791,958269,518071,386416,390112,582364,842449,191334,1005327,164152,789434,184950,685166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001922s ]