SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406680 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406680 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361458,501070,586409,388819,502933,238927,164655,81493,498359,978741,613292,257298,562699,573755,92707,580277,396306,709320,701029,977733,518492,472525,961994,1011333,965437,7010,959050,450048,194592,95310,287210,263133,124843,767531,137335,51385,616255,1020911,640681,137579,940129,369794,261502,309253,41819,878369,415728,175856,439257,200822,479139,998088,973065,532128,126092,951604,127226,348450,580733,855920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000377s ]