SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408649 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408649 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134928,857248,881307,203543,1048125,1012675,815775,557386,704348,475346,995011,828321,286031,576704,486588,464050,854601,670645,896011,976832,454548,659034,996556,145681,96784,117743,27924,267917,197508,433006,100426,785466,267817,758090,677889,213257,568441,731469,293098,880057,789720,780300,564165,604642,530259,720636,894789,416431,1028216,555896,575393,868740,115102,182504,992824,335556,80841,227529,602505,911414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]