SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001667s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000316 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000316 [ RunTime:0.005670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670613,806361,691214,959428,165289,789445,3217,215220,105140,950911,427387,524686,75332,10655,302742,518902,175692,954923,151109,605191,812148,244717,961977,190942,424348,26021,32348,310235,781807,84069,1023420,466150,975602,772629,513314,738070,462833,293540,934212,655784,502162,70733,899005,115483,707977,150227,881977,169312,25864,15781,725688,545943,990745,477934,698021,610145,353135,75565,157133,1011640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]