SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430046 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430046 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408168,890233,1008653,154527,23999,837983,57852,85090,338272,757344,278142,364247,1044352,98293,618015,270910,1017220,487789,908053,642518,944074,13226,617425,377598,786592,847991,761449,592112,211284,23069,764089,543441,337317,1010710,601012,660317,594904,717360,143111,148332,599229,254382,1034742,849059,854307,620266,474006,551180,789247,387876,564935,208573,738927,637243,456580,487306,567038,731228,888665,518691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]