SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325003 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325003 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382121,520807,492142,665565,176538,860179,716560,922794,683620,661572,365431,516147,924457,957430,265267,13383,109986,280075,925348,331407,42166,640890,830014,160601,648557,24198,867584,141270,515432,834404,160314,657623,239587,82458,402555,76438,1005222,182979,912760,8013,316478,883112,524258,364387,772030,316444,950175,367158,1028111,618469,208730,375819,567097,780278,234779,434660,651879,802654,980919,399830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003382s ]