SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391822 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391822 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570147,33284,377455,499951,979568,919780,639387,523986,236167,422974,295907,388954,921444,444418,673164,151257,149100,216475,207310,224817,310473,284825,363195,966738,471048,220407,194529,478749,338092,673888,236993,890499,608543,635218,96487,227491,148378,133801,953233,605795,493777,244522,659933,451874,973078,547840,592662,257893,43526,220340,573561,361739,968576,787759,70221,193768,648882,769067,7624,590271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]