SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481329 LIMIT 1 [ RunTime:0.000672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481329 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146717,333114,522835,328578,109015,1016288,776389,705944,414266,241658,231227,386587,469737,640910,620351,757613,653228,826058,825846,765658,113481,579163,841876,272656,827285,126534,744444,493097,586978,930921,269556,92249,150602,39439,847591,110038,246471,300302,449279,634031,229366,859448,141427,997849,488146,813389,42624,1004433,785414,449370,772452,165099,875803,876778,833185,317346,109792,239009,410776,995668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]