SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284398 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284398 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277530,972273,672785,1023212,637691,771471,672310,146258,399120,95611,947919,192137,265020,254382,898042,860046,19903,842910,824300,361955,83430,126337,510252,209638,776641,354184,341453,726576,275972,58328,376888,976747,346243,882752,634993,844702,42113,150124,956308,190987,782004,374358,842005,169708,647393,608936,650401,407220,789428,216529,331876,136690,815873,124934,1022812,1003675,302072,880139,483352,586754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]