SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291121 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291121 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436351,636825,761011,162629,872513,410216,402935,348438,556300,108155,198031,633890,389056,848394,693112,513385,584169,730407,141034,1022929,847502,56565,1036499,668308,804671,99628,932681,1048171,504189,349426,273228,741916,270382,1002393,504306,349478,319075,61880,528791,96556,125433,620729,605671,74545,93064,185640,460451,566830,325758,697010,982450,212745,398557,417173,1022417,603406,186771,443754,916032,204586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]