SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451496 LIMIT 1 [ RunTime:0.001010s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451496 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039549,137497,430088,741208,793649,257961,885400,405861,575237,556676,303528,958484,596346,938920,203621,965145,910959,377922,835355,1034031,937137,424788,628203,17081,167792,231793,306580,846121,829173,719998,278388,990353,1031297,76792,631526,254659,630635,729783,484317,995360,425372,150154,400181,867389,240126,182258,1013313,167698,845457,283170,954200,500292,599802,949067,513294,777640,577503,141578,499772,153716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003216s ]