SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482551 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482551 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871666,142134,886263,607877,59368,147316,252693,684849,918523,758001,322138,680045,395520,341176,344883,205447,613651,30774,234943,783185,410827,543834,279082,199665,502308,476202,677780,209427,996710,764931,724881,485423,423869,129635,34526,428977,987885,558253,151015,106971,103343,687691,398497,790284,89768,174752,681201,589185,696819,17315,908914,364380,232337,771348,357726,546934,282001,448388,466455,263256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]