SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267021 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267021 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79903,626160,930850,1037221,72770,717350,60236,538428,288244,305230,674018,129675,702833,854854,117889,361262,481518,369238,674650,233078,204663,40707,888327,35214,861318,492817,88902,130358,236183,498218,182527,964752,121181,636051,683228,46041,878336,102074,418361,720507,538973,673408,952269,572289,623922,398433,736788,690256,706751,422372,126799,1021438,573473,690740,162404,394138,271214,947055,102876,384639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001115s ]