SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001831s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040931 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040931 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405048,860795,360380,100996,560180,559602,402581,431117,7025,739226,712936,214752,990363,172004,718526,122035,708242,980620,470824,497618,672047,822126,454011,89385,117666,878415,444596,911308,151663,268990,422302,30525,49649,313770,818460,396824,919026,764178,178110,252520,7895,881981,671705,92471,957507,586750,713948,348919,256449,1006725,39264,677375,18363,266584,216517,101087,485197,914013,352047,296652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]