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` = 311281 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311281 [ RunTime:0.002992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515152,658611,204166,726255,896656,394208,173735,233524,244313,501443,127800,425315,444789,467430,23250,935718,262039,753952,684268,667077,143659,996612,647204,562789,984598,906700,874385,496652,890641,106924,881688,710933,858818,660814,945928,454580,690508,616999,233044,745453,247555,824079,885425,461507,434916,907540,500760,308873,451510,916145,1038799,957342,854411,290907,594795,743430,197224,617663,630696,851654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]