SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458454 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458454 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341088,327403,205823,921475,373551,189487,201208,396336,793149,304801,192170,606790,647323,528186,510271,445421,831636,496055,291555,924574,486593,205799,49792,842510,989342,539405,648600,757923,386551,200350,1024528,825449,1043600,63049,522394,548597,802971,66928,528149,578354,699593,993911,717795,409757,620434,742646,842355,567658,506308,339083,1024335,752166,641251,50968,116307,386117,834536,205756,1018504,994808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]