SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500810 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500810 [ RunTime:0.002221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488668,442708,383973,868498,27561,796947,366158,681386,689894,954258,873401,515517,83576,941085,153931,226563,939428,200967,892713,472323,391494,244584,26366,988895,143802,157000,987538,652100,707238,961999,672224,750741,969118,290484,1035029,802435,148300,555907,394469,572773,635751,741839,416337,930333,487816,921873,692366,502730,650838,434172,1013242,412900,217744,170721,142003,638944,1047461,483478,230240,502035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000960s ]