SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201687 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201687 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206972,721000,12544,639613,693304,136567,440534,233309,330981,816825,900639,919148,274447,714731,208798,181625,471928,787492,905331,691466,906998,132478,236261,106217,916478,187514,626121,858714,972230,282000,119034,558746,400874,971597,291127,345100,651946,596024,350193,182021,75959,1005124,333063,564125,833084,273998,684855,744057,987211,650688,328455,60505,939658,82223,995404,397415,1047964,628715,218938,589387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]