SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022379 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022379 [ RunTime:0.002671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497146,780558,857359,1012161,519663,414233,425536,973468,265504,709586,941018,673379,210220,2916,301874,801221,55444,533675,641511,909880,540943,639281,984614,18088,50154,505408,130124,163697,371632,42067,925051,634053,739954,918004,489599,426800,571453,281253,836405,658481,443960,497473,243491,210385,671046,878808,708413,846946,626564,12772,12905,239040,389775,642465,1005714,725498,342958,692924,650154,620620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022379 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022379 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]