SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4187 LIMIT 1 [ RunTime:0.001197s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4187 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303015,502323,168647,844499,522237,309401,344761,339640,761912,670219,712727,357567,808318,517916,406093,131627,245206,304589,237327,232592,4136,876053,823168,626649,905252,618414,144463,210569,710022,1044375,262356,20138,908125,730512,783865,183152,278993,392463,224864,556547,87686,601812,274248,252558,339277,394924,160388,897613,1007722,766523,120496,873755,315505,1048920,571627,900670,154268,911858,458541,97042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]