SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521836 LIMIT 1 [ RunTime:0.002290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521836 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107111,674326,937718,728420,764824,881826,179589,825822,626541,242120,905323,672322,7025,885765,26928,480992,624823,161689,776371,123284,818582,149215,886176,369565,859559,569833,12703,572886,254261,757054,476782,471393,200678,930561,946601,956109,310517,497059,1023866,962725,171488,208152,731481,382260,97099,858714,513960,669188,790763,312030,425317,944152,611749,198250,308618,162839,312209,790479,57122,361807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]