SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478843 LIMIT 1 [ RunTime:0.003661s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478843 [ RunTime:0.005554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490642,876770,281911,591619,368851,705499,847772,75329,806226,126438,239704,89380,1001080,210799,243989,679403,9132,1046533,745319,167855,677452,65042,839018,1042415,103079,87766,348134,1036226,470254,626614,936278,957589,581607,839950,153299,12533,14224,750673,352054,642216,354693,696747,61089,432982,227512,555743,895524,117887,582926,72367,956745,222843,719204,452737,664486,600301,546527,936175,782857,87821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]