SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040382 LIMIT 1 [ RunTime:0.000918s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040382 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795404,358190,22264,806101,239945,1001907,701061,98447,411929,160422,713538,906898,590092,87909,288753,311980,1030677,715133,202889,516043,1041067,937997,576539,204249,129363,215649,37566,407247,51899,535589,858899,1043421,212780,329673,172822,323193,27153,463502,58610,700045,523084,668632,547,111454,962368,594012,287591,609331,655137,1037407,766084,109797,1046749,890682,668020,1032295,80457,389935,889271,88478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]