SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406836 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406836 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662273,918741,113777,156781,45423,1003773,790769,467943,1031313,245706,465183,90339,441469,967308,981189,430918,760921,357786,582399,902475,782240,791866,159464,835715,750321,1048399,1001389,263936,846003,250294,861774,1018795,547129,448932,1006119,46050,556969,296140,166711,526861,170897,772822,347569,443886,1001477,799822,21775,969878,1047812,1019622,110235,249519,750191,676650,441122,534921,396934,1025896,834346,1001099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]