SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310413 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310413 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317398,23990,782123,88560,694937,643446,286544,41689,631088,928063,170069,337300,972030,403846,498712,199954,349169,419352,912938,26814,917566,694474,524193,453353,885157,241339,307391,731883,574711,930385,490472,980434,864936,532783,423694,731557,637131,641638,610505,1032652,120632,369383,422573,501009,857873,239215,787287,996373,840105,776608,911846,1036058,155404,1044664,144416,149678,769696,1000313,397194,960535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]